<HTML>
<BODY BGCOLOR="white">
<PRE>
<FONT color="green">001</FONT>    /*<a name="line.1"></a>
<FONT color="green">002</FONT>     * Licensed to the Apache Software Foundation (ASF) under one or more<a name="line.2"></a>
<FONT color="green">003</FONT>     * contributor license agreements.  See the NOTICE file distributed with<a name="line.3"></a>
<FONT color="green">004</FONT>     * this work for additional information regarding copyright ownership.<a name="line.4"></a>
<FONT color="green">005</FONT>     * The ASF licenses this file to You under the Apache License, Version 2.0<a name="line.5"></a>
<FONT color="green">006</FONT>     * (the "License"); you may not use this file except in compliance with<a name="line.6"></a>
<FONT color="green">007</FONT>     * the License.  You may obtain a copy of the License at<a name="line.7"></a>
<FONT color="green">008</FONT>     * <a name="line.8"></a>
<FONT color="green">009</FONT>     *      http://www.apache.org/licenses/LICENSE-2.0<a name="line.9"></a>
<FONT color="green">010</FONT>     * <a name="line.10"></a>
<FONT color="green">011</FONT>     * Unless required by applicable law or agreed to in writing, software<a name="line.11"></a>
<FONT color="green">012</FONT>     * distributed under the License is distributed on an "AS IS" BASIS,<a name="line.12"></a>
<FONT color="green">013</FONT>     * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.<a name="line.13"></a>
<FONT color="green">014</FONT>     * See the License for the specific language governing permissions and<a name="line.14"></a>
<FONT color="green">015</FONT>     * limitations under the License.<a name="line.15"></a>
<FONT color="green">016</FONT>     */<a name="line.16"></a>
<FONT color="green">017</FONT>    <a name="line.17"></a>
<FONT color="green">018</FONT>    package org.apache.commons.dbcp;<a name="line.18"></a>
<FONT color="green">019</FONT>    <a name="line.19"></a>
<FONT color="green">020</FONT>    import java.io.PrintWriter;<a name="line.20"></a>
<FONT color="green">021</FONT>    import java.util.Properties;<a name="line.21"></a>
<FONT color="green">022</FONT>    import java.util.Collection;<a name="line.22"></a>
<FONT color="green">023</FONT>    import java.util.List;<a name="line.23"></a>
<FONT color="green">024</FONT>    import java.util.ArrayList;<a name="line.24"></a>
<FONT color="green">025</FONT>    import java.util.Iterator;<a name="line.25"></a>
<FONT color="green">026</FONT>    import java.util.Collections;<a name="line.26"></a>
<FONT color="green">027</FONT>    import java.sql.Connection;<a name="line.27"></a>
<FONT color="green">028</FONT>    import java.sql.Driver;<a name="line.28"></a>
<FONT color="green">029</FONT>    import java.sql.DriverManager;<a name="line.29"></a>
<FONT color="green">030</FONT>    import java.sql.SQLException;<a name="line.30"></a>
<FONT color="green">031</FONT>    import javax.sql.DataSource;<a name="line.31"></a>
<FONT color="green">032</FONT>    <a name="line.32"></a>
<FONT color="green">033</FONT>    import org.apache.commons.pool.KeyedObjectPoolFactory;<a name="line.33"></a>
<FONT color="green">034</FONT>    import org.apache.commons.pool.impl.GenericKeyedObjectPool;<a name="line.34"></a>
<FONT color="green">035</FONT>    import org.apache.commons.pool.impl.GenericKeyedObjectPoolFactory;<a name="line.35"></a>
<FONT color="green">036</FONT>    import org.apache.commons.pool.impl.GenericObjectPool;<a name="line.36"></a>
<FONT color="green">037</FONT>    <a name="line.37"></a>
<FONT color="green">038</FONT>    <a name="line.38"></a>
<FONT color="green">039</FONT>    /**<a name="line.39"></a>
<FONT color="green">040</FONT>     * &lt;p&gt;Basic implementation of &lt;code&gt;javax.sql.DataSource&lt;/code&gt; that is<a name="line.40"></a>
<FONT color="green">041</FONT>     * configured via JavaBeans properties.  This is not the only way to<a name="line.41"></a>
<FONT color="green">042</FONT>     * combine the &lt;em&gt;commons-dbcp&lt;/em&gt; and &lt;em&gt;commons-pool&lt;/em&gt; packages,<a name="line.42"></a>
<FONT color="green">043</FONT>     * but provides a "one stop shopping" solution for basic requirements.&lt;/p&gt;<a name="line.43"></a>
<FONT color="green">044</FONT>     * <a name="line.44"></a>
<FONT color="green">045</FONT>     * &lt;p&gt;Users extending this class should take care to use appropriate accessors<a name="line.45"></a>
<FONT color="green">046</FONT>     * rather than accessing protected fields directly to ensure thread-safety.&lt;/p&gt;<a name="line.46"></a>
<FONT color="green">047</FONT>     *<a name="line.47"></a>
<FONT color="green">048</FONT>     * @author Glenn L. Nielsen<a name="line.48"></a>
<FONT color="green">049</FONT>     * @author Craig R. McClanahan<a name="line.49"></a>
<FONT color="green">050</FONT>     * @author Dirk Verbeeck<a name="line.50"></a>
<FONT color="green">051</FONT>     * @version $Revision: 895844 $ $Date: 2010-01-04 20:50:04 -0500 (Mon, 04 Jan 2010) $<a name="line.51"></a>
<FONT color="green">052</FONT>     */<a name="line.52"></a>
<FONT color="green">053</FONT>    public class BasicDataSource implements DataSource {<a name="line.53"></a>
<FONT color="green">054</FONT>        <a name="line.54"></a>
<FONT color="green">055</FONT>        static {<a name="line.55"></a>
<FONT color="green">056</FONT>            // Attempt to prevent deadlocks - see DBCP - 272<a name="line.56"></a>
<FONT color="green">057</FONT>            DriverManager.getDrivers();<a name="line.57"></a>
<FONT color="green">058</FONT>        }<a name="line.58"></a>
<FONT color="green">059</FONT>    <a name="line.59"></a>
<FONT color="green">060</FONT>        // ------------------------------------------------------------- Properties<a name="line.60"></a>
<FONT color="green">061</FONT>    <a name="line.61"></a>
<FONT color="green">062</FONT>        /**<a name="line.62"></a>
<FONT color="green">063</FONT>         * The default auto-commit state of connections created by this pool.<a name="line.63"></a>
<FONT color="green">064</FONT>         */<a name="line.64"></a>
<FONT color="green">065</FONT>        protected volatile boolean defaultAutoCommit = true;<a name="line.65"></a>
<FONT color="green">066</FONT>    <a name="line.66"></a>
<FONT color="green">067</FONT>        /**<a name="line.67"></a>
<FONT color="green">068</FONT>         * Returns the default auto-commit property.<a name="line.68"></a>
<FONT color="green">069</FONT>         * <a name="line.69"></a>
<FONT color="green">070</FONT>         * @return true if default auto-commit is enabled<a name="line.70"></a>
<FONT color="green">071</FONT>         */<a name="line.71"></a>
<FONT color="green">072</FONT>        public boolean getDefaultAutoCommit() {<a name="line.72"></a>
<FONT color="green">073</FONT>            return this.defaultAutoCommit;<a name="line.73"></a>
<FONT color="green">074</FONT>        }<a name="line.74"></a>
<FONT color="green">075</FONT>    <a name="line.75"></a>
<FONT color="green">076</FONT>        /**<a name="line.76"></a>
<FONT color="green">077</FONT>         * &lt;p&gt;Sets default auto-commit state of connections returned by this<a name="line.77"></a>
<FONT color="green">078</FONT>         * datasource.&lt;/p&gt;<a name="line.78"></a>
<FONT color="green">079</FONT>         * &lt;p&gt;<a name="line.79"></a>
<FONT color="green">080</FONT>         * Note: this method currently has no effect once the pool has been<a name="line.80"></a>
<FONT color="green">081</FONT>         * initialized.  The pool is initialized the first time one of the<a name="line.81"></a>
<FONT color="green">082</FONT>         * following methods is invoked: &lt;code&gt;getConnection, setLogwriter,<a name="line.82"></a>
<FONT color="green">083</FONT>         * setLoginTimeout, getLoginTimeout, getLogWriter.&lt;/code&gt;&lt;/p&gt;<a name="line.83"></a>
<FONT color="green">084</FONT>         * <a name="line.84"></a>
<FONT color="green">085</FONT>         * @param defaultAutoCommit default auto-commit value<a name="line.85"></a>
<FONT color="green">086</FONT>         */<a name="line.86"></a>
<FONT color="green">087</FONT>        public void setDefaultAutoCommit(boolean defaultAutoCommit) {<a name="line.87"></a>
<FONT color="green">088</FONT>            this.defaultAutoCommit = defaultAutoCommit;<a name="line.88"></a>
<FONT color="green">089</FONT>            this.restartNeeded = true;<a name="line.89"></a>
<FONT color="green">090</FONT>        }<a name="line.90"></a>
<FONT color="green">091</FONT>    <a name="line.91"></a>
<FONT color="green">092</FONT>    <a name="line.92"></a>
<FONT color="green">093</FONT>        /**<a name="line.93"></a>
<FONT color="green">094</FONT>         * The default read-only state of connections created by this pool.<a name="line.94"></a>
<FONT color="green">095</FONT>         */<a name="line.95"></a>
<FONT color="green">096</FONT>        protected transient Boolean defaultReadOnly = null;<a name="line.96"></a>
<FONT color="green">097</FONT>    <a name="line.97"></a>
<FONT color="green">098</FONT>        /**<a name="line.98"></a>
<FONT color="green">099</FONT>         * Returns the default readOnly property.<a name="line.99"></a>
<FONT color="green">100</FONT>         * <a name="line.100"></a>
<FONT color="green">101</FONT>         * @return true if connections are readOnly by default<a name="line.101"></a>
<FONT color="green">102</FONT>         */<a name="line.102"></a>
<FONT color="green">103</FONT>        public boolean getDefaultReadOnly() {<a name="line.103"></a>
<FONT color="green">104</FONT>            Boolean val = defaultReadOnly;<a name="line.104"></a>
<FONT color="green">105</FONT>            if (val != null) {<a name="line.105"></a>
<FONT color="green">106</FONT>                return val.booleanValue();<a name="line.106"></a>
<FONT color="green">107</FONT>            }<a name="line.107"></a>
<FONT color="green">108</FONT>            return false;<a name="line.108"></a>
<FONT color="green">109</FONT>        }<a name="line.109"></a>
<FONT color="green">110</FONT>    <a name="line.110"></a>
<FONT color="green">111</FONT>        /**<a name="line.111"></a>
<FONT color="green">112</FONT>         * &lt;p&gt;Sets defaultReadonly property.&lt;/p&gt;<a name="line.112"></a>
<FONT color="green">113</FONT>         * &lt;p&gt;<a name="line.113"></a>
<FONT color="green">114</FONT>         * Note: this method currently has no effect once the pool has been<a name="line.114"></a>
<FONT color="green">115</FONT>         * initialized.  The pool is initialized the first time one of the<a name="line.115"></a>
<FONT color="green">116</FONT>         * following methods is invoked: &lt;code&gt;getConnection, setLogwriter,<a name="line.116"></a>
<FONT color="green">117</FONT>         * setLoginTimeout, getLoginTimeout, getLogWriter.&lt;/code&gt;&lt;/p&gt;<a name="line.117"></a>
<FONT color="green">118</FONT>         * <a name="line.118"></a>
<FONT color="green">119</FONT>         * @param defaultReadOnly default read-only value<a name="line.119"></a>
<FONT color="green">120</FONT>         */<a name="line.120"></a>
<FONT color="green">121</FONT>        public void setDefaultReadOnly(boolean defaultReadOnly) {<a name="line.121"></a>
<FONT color="green">122</FONT>            this.defaultReadOnly = defaultReadOnly ? Boolean.TRUE : Boolean.FALSE;<a name="line.122"></a>
<FONT color="green">123</FONT>            this.restartNeeded = true;<a name="line.123"></a>
<FONT color="green">124</FONT>        }<a name="line.124"></a>
<FONT color="green">125</FONT>    <a name="line.125"></a>
<FONT color="green">126</FONT>        /**<a name="line.126"></a>
<FONT color="green">127</FONT>         * The default TransactionIsolation state of connections created by this pool.<a name="line.127"></a>
<FONT color="green">128</FONT>         */<a name="line.128"></a>
<FONT color="green">129</FONT>        protected volatile int defaultTransactionIsolation =<a name="line.129"></a>
<FONT color="green">130</FONT>            PoolableConnectionFactory.UNKNOWN_TRANSACTIONISOLATION;<a name="line.130"></a>
<FONT color="green">131</FONT>    <a name="line.131"></a>
<FONT color="green">132</FONT>        /**<a name="line.132"></a>
<FONT color="green">133</FONT>         * Returns the default transaction isolation state of returned connections.<a name="line.133"></a>
<FONT color="green">134</FONT>         * <a name="line.134"></a>
<FONT color="green">135</FONT>         * @return the default value for transaction isolation state<a name="line.135"></a>
<FONT color="green">136</FONT>         * @see Connection#getTransactionIsolation<a name="line.136"></a>
<FONT color="green">137</FONT>         */<a name="line.137"></a>
<FONT color="green">138</FONT>        public int getDefaultTransactionIsolation() {<a name="line.138"></a>
<FONT color="green">139</FONT>            return this.defaultTransactionIsolation;<a name="line.139"></a>
<FONT color="green">140</FONT>        }<a name="line.140"></a>
<FONT color="green">141</FONT>    <a name="line.141"></a>
<FONT color="green">142</FONT>        /**<a name="line.142"></a>
<FONT color="green">143</FONT>         * &lt;p&gt;Sets the default transaction isolation state for returned<a name="line.143"></a>
<FONT color="green">144</FONT>         * connections.&lt;/p&gt;<a name="line.144"></a>
<FONT color="green">145</FONT>         * &lt;p&gt;<a name="line.145"></a>
<FONT color="green">146</FONT>         * Note: this method currently has no effect once the pool has been<a name="line.146"></a>
<FONT color="green">147</FONT>         * initialized.  The pool is initialized the first time one of the<a name="line.147"></a>
<FONT color="green">148</FONT>         * following methods is invoked: &lt;code&gt;getConnection, setLogwriter,<a name="line.148"></a>
<FONT color="green">149</FONT>         * setLoginTimeout, getLoginTimeout, getLogWriter.&lt;/code&gt;&lt;/p&gt;<a name="line.149"></a>
<FONT color="green">150</FONT>         * <a name="line.150"></a>
<FONT color="green">151</FONT>         * @param defaultTransactionIsolation the default transaction isolation<a name="line.151"></a>
<FONT color="green">152</FONT>         * state<a name="line.152"></a>
<FONT color="green">153</FONT>         * @see Connection#getTransactionIsolation<a name="line.153"></a>
<FONT color="green">154</FONT>         */<a name="line.154"></a>
<FONT color="green">155</FONT>        public void setDefaultTransactionIsolation(int defaultTransactionIsolation) {<a name="line.155"></a>
<FONT color="green">156</FONT>            this.defaultTransactionIsolation = defaultTransactionIsolation;<a name="line.156"></a>
<FONT color="green">157</FONT>            this.restartNeeded = true;<a name="line.157"></a>
<FONT color="green">158</FONT>        }<a name="line.158"></a>
<FONT color="green">159</FONT>    <a name="line.159"></a>
<FONT color="green">160</FONT>    <a name="line.160"></a>
<FONT color="green">161</FONT>        /**<a name="line.161"></a>
<FONT color="green">162</FONT>         * The default "catalog" of connections created by this pool.<a name="line.162"></a>
<FONT color="green">163</FONT>         */<a name="line.163"></a>
<FONT color="green">164</FONT>        protected volatile String defaultCatalog = null;<a name="line.164"></a>
<FONT color="green">165</FONT>    <a name="line.165"></a>
<FONT color="green">166</FONT>        /**<a name="line.166"></a>
<FONT color="green">167</FONT>         * Returns the default catalog.<a name="line.167"></a>
<FONT color="green">168</FONT>         * <a name="line.168"></a>
<FONT color="green">169</FONT>         * @return the default catalog<a name="line.169"></a>
<FONT color="green">170</FONT>         */<a name="line.170"></a>
<FONT color="green">171</FONT>        public String getDefaultCatalog() {<a name="line.171"></a>
<FONT color="green">172</FONT>            return this.defaultCatalog;<a name="line.172"></a>
<FONT color="green">173</FONT>        }<a name="line.173"></a>
<FONT color="green">174</FONT>    <a name="line.174"></a>
<FONT color="green">175</FONT>        /**<a name="line.175"></a>
<FONT color="green">176</FONT>         * &lt;p&gt;Sets the default catalog.&lt;/p&gt;<a name="line.176"></a>
<FONT color="green">177</FONT>         * &lt;p&gt;<a name="line.177"></a>
<FONT color="green">178</FONT>         * Note: this method currently has no effect once the pool has been<a name="line.178"></a>
<FONT color="green">179</FONT>         * initialized.  The pool is initialized the first time one of the<a name="line.179"></a>
<FONT color="green">180</FONT>         * following methods is invoked: &lt;code&gt;getConnection, setLogwriter,<a name="line.180"></a>
<FONT color="green">181</FONT>         * setLoginTimeout, getLoginTimeout, getLogWriter.&lt;/code&gt;&lt;/p&gt;<a name="line.181"></a>
<FONT color="green">182</FONT>         * <a name="line.182"></a>
<FONT color="green">183</FONT>         * @param defaultCatalog the default catalog<a name="line.183"></a>
<FONT color="green">184</FONT>         */<a name="line.184"></a>
<FONT color="green">185</FONT>        public void setDefaultCatalog(String defaultCatalog) {<a name="line.185"></a>
<FONT color="green">186</FONT>            if ((defaultCatalog != null) &amp;&amp; (defaultCatalog.trim().length() &gt; 0)) {<a name="line.186"></a>
<FONT color="green">187</FONT>                this.defaultCatalog = defaultCatalog;<a name="line.187"></a>
<FONT color="green">188</FONT>            }<a name="line.188"></a>
<FONT color="green">189</FONT>            else {<a name="line.189"></a>
<FONT color="green">190</FONT>                this.defaultCatalog = null;<a name="line.190"></a>
<FONT color="green">191</FONT>            }<a name="line.191"></a>
<FONT color="green">192</FONT>            this.restartNeeded = true;<a name="line.192"></a>
<FONT color="green">193</FONT>        }<a name="line.193"></a>
<FONT color="green">194</FONT>    <a name="line.194"></a>
<FONT color="green">195</FONT>      <a name="line.195"></a>
<FONT color="green">196</FONT>        /**<a name="line.196"></a>
<FONT color="green">197</FONT>         * The fully qualified Java class name of the JDBC driver to be used.<a name="line.197"></a>
<FONT color="green">198</FONT>         */<a name="line.198"></a>
<FONT color="green">199</FONT>        protected String driverClassName = null;<a name="line.199"></a>
<FONT color="green">200</FONT>    <a name="line.200"></a>
<FONT color="green">201</FONT>        /**<a name="line.201"></a>
<FONT color="green">202</FONT>         * Returns the jdbc driver class name.<a name="line.202"></a>
<FONT color="green">203</FONT>         * <a name="line.203"></a>
<FONT color="green">204</FONT>         * @return the jdbc driver class name<a name="line.204"></a>
<FONT color="green">205</FONT>         */<a name="line.205"></a>
<FONT color="green">206</FONT>        public synchronized String getDriverClassName() {<a name="line.206"></a>
<FONT color="green">207</FONT>            return this.driverClassName;<a name="line.207"></a>
<FONT color="green">208</FONT>        }<a name="line.208"></a>
<FONT color="green">209</FONT>    <a name="line.209"></a>
<FONT color="green">210</FONT>        /**<a name="line.210"></a>
<FONT color="green">211</FONT>         * &lt;p&gt;Sets the jdbc driver class name.&lt;/p&gt;<a name="line.211"></a>
<FONT color="green">212</FONT>         * &lt;p&gt;<a name="line.212"></a>
<FONT color="green">213</FONT>         * Note: this method currently has no effect once the pool has been<a name="line.213"></a>
<FONT color="green">214</FONT>         * initialized.  The pool is initialized the first time one of the<a name="line.214"></a>
<FONT color="green">215</FONT>         * following methods is invoked: &lt;code&gt;getConnection, setLogwriter,<a name="line.215"></a>
<FONT color="green">216</FONT>         * setLoginTimeout, getLoginTimeout, getLogWriter.&lt;/code&gt;&lt;/p&gt;<a name="line.216"></a>
<FONT color="green">217</FONT>         * <a name="line.217"></a>
<FONT color="green">218</FONT>         * @param driverClassName the class name of the jdbc driver<a name="line.218"></a>
<FONT color="green">219</FONT>         */<a name="line.219"></a>
<FONT color="green">220</FONT>        public synchronized void setDriverClassName(String driverClassName) {<a name="line.220"></a>
<FONT color="green">221</FONT>            if ((driverClassName != null) &amp;&amp; (driverClassName.trim().length() &gt; 0)) {<a name="line.221"></a>
<FONT color="green">222</FONT>                this.driverClassName = driverClassName;<a name="line.222"></a>
<FONT color="green">223</FONT>            }<a name="line.223"></a>
<FONT color="green">224</FONT>            else {<a name="line.224"></a>
<FONT color="green">225</FONT>                this.driverClassName = null;<a name="line.225"></a>
<FONT color="green">226</FONT>            }<a name="line.226"></a>
<FONT color="green">227</FONT>            this.restartNeeded = true;<a name="line.227"></a>
<FONT color="green">228</FONT>        }<a name="line.228"></a>
<FONT color="green">229</FONT>    <a name="line.229"></a>
<FONT color="green">230</FONT>        /**<a name="line.230"></a>
<FONT color="green">231</FONT>         * The class loader instance to use to load the JDBC driver. If not<a name="line.231"></a>
<FONT color="green">232</FONT>         * specified, {@link Class#forName(String)} is used to load the JDBC driver.<a name="line.232"></a>
<FONT color="green">233</FONT>         * If specified, {@link Class#forName(String, boolean, ClassLoader)} is<a name="line.233"></a>
<FONT color="green">234</FONT>         * used.<a name="line.234"></a>
<FONT color="green">235</FONT>         */<a name="line.235"></a>
<FONT color="green">236</FONT>        protected ClassLoader driverClassLoader = null;<a name="line.236"></a>
<FONT color="green">237</FONT>        <a name="line.237"></a>
<FONT color="green">238</FONT>        /**<a name="line.238"></a>
<FONT color="green">239</FONT>         * Returns the class loader specified for loading the JDBC driver. Returns<a name="line.239"></a>
<FONT color="green">240</FONT>         * &lt;code&gt;null&lt;/code&gt; if no class loader has been explicitly specified.<a name="line.240"></a>
<FONT color="green">241</FONT>         */<a name="line.241"></a>
<FONT color="green">242</FONT>        public synchronized ClassLoader getDriverClassLoader() {<a name="line.242"></a>
<FONT color="green">243</FONT>            return this.driverClassLoader;<a name="line.243"></a>
<FONT color="green">244</FONT>        }<a name="line.244"></a>
<FONT color="green">245</FONT>    <a name="line.245"></a>
<FONT color="green">246</FONT>        /**<a name="line.246"></a>
<FONT color="green">247</FONT>         * &lt;p&gt;Sets the class loader to be used to load the JDBC driver.&lt;/p&gt;<a name="line.247"></a>
<FONT color="green">248</FONT>         * &lt;p&gt;<a name="line.248"></a>
<FONT color="green">249</FONT>         * Note: this method currently has no effect once the pool has been<a name="line.249"></a>
<FONT color="green">250</FONT>         * initialized.  The pool is initialized the first time one of the<a name="line.250"></a>
<FONT color="green">251</FONT>         * following methods is invoked: &lt;code&gt;getConnection, setLogwriter,<a name="line.251"></a>
<FONT color="green">252</FONT>         * setLoginTimeout, getLoginTimeout, getLogWriter.&lt;/code&gt;&lt;/p&gt;<a name="line.252"></a>
<FONT color="green">253</FONT>         * <a name="line.253"></a>
<FONT color="green">254</FONT>         * @param driverClassLoader the class loader with which to load the JDBC<a name="line.254"></a>
<FONT color="green">255</FONT>         *                          driver<a name="line.255"></a>
<FONT color="green">256</FONT>         */<a name="line.256"></a>
<FONT color="green">257</FONT>        public synchronized void setDriverClassLoader(<a name="line.257"></a>
<FONT color="green">258</FONT>                ClassLoader driverClassLoader) {<a name="line.258"></a>
<FONT color="green">259</FONT>            this.driverClassLoader = driverClassLoader;<a name="line.259"></a>
<FONT color="green">260</FONT>            this.restartNeeded = true;<a name="line.260"></a>
<FONT color="green">261</FONT>        }<a name="line.261"></a>
<FONT color="green">262</FONT>        <a name="line.262"></a>
<FONT color="green">263</FONT>        /**<a name="line.263"></a>
<FONT color="green">264</FONT>         * The maximum number of active connections that can be allocated from<a name="line.264"></a>
<FONT color="green">265</FONT>         * this pool at the same time, or negative for no limit.<a name="line.265"></a>
<FONT color="green">266</FONT>         */<a name="line.266"></a>
<FONT color="green">267</FONT>        protected int maxActive = GenericObjectPool.DEFAULT_MAX_ACTIVE;<a name="line.267"></a>
<FONT color="green">268</FONT>    <a name="line.268"></a>
<FONT color="green">269</FONT>        /**<a name="line.269"></a>
<FONT color="green">270</FONT>         * &lt;p&gt;Returns the maximum number of active connections that can be<a name="line.270"></a>
<FONT color="green">271</FONT>         * allocated at the same time.<a name="line.271"></a>
<FONT color="green">272</FONT>         * &lt;/p&gt;<a name="line.272"></a>
<FONT color="green">273</FONT>         * &lt;p&gt;A negative number means that there is no limit.&lt;/p&gt;<a name="line.273"></a>
<FONT color="green">274</FONT>         * <a name="line.274"></a>
<FONT color="green">275</FONT>         * @return the maximum number of active connections<a name="line.275"></a>
<FONT color="green">276</FONT>         */<a name="line.276"></a>
<FONT color="green">277</FONT>        public synchronized int getMaxActive() {<a name="line.277"></a>
<FONT color="green">278</FONT>            return this.maxActive;<a name="line.278"></a>
<FONT color="green">279</FONT>        }<a name="line.279"></a>
<FONT color="green">280</FONT>    <a name="line.280"></a>
<FONT color="green">281</FONT>        /**<a name="line.281"></a>
<FONT color="green">282</FONT>         * Sets the maximum number of active connections that can be<a name="line.282"></a>
<FONT color="green">283</FONT>         * allocated at the same time. Use a negative value for no limit.<a name="line.283"></a>
<FONT color="green">284</FONT>         * <a name="line.284"></a>
<FONT color="green">285</FONT>         * @param maxActive the new value for maxActive<a name="line.285"></a>
<FONT color="green">286</FONT>         * @see #getMaxActive()<a name="line.286"></a>
<FONT color="green">287</FONT>         */<a name="line.287"></a>
<FONT color="green">288</FONT>        public synchronized void setMaxActive(int maxActive) {<a name="line.288"></a>
<FONT color="green">289</FONT>            this.maxActive = maxActive;<a name="line.289"></a>
<FONT color="green">290</FONT>            if (connectionPool != null) {<a name="line.290"></a>
<FONT color="green">291</FONT>                connectionPool.setMaxActive(maxActive);<a name="line.291"></a>
<FONT color="green">292</FONT>            }<a name="line.292"></a>
<FONT color="green">293</FONT>        }<a name="line.293"></a>
<FONT color="green">294</FONT>    <a name="line.294"></a>
<FONT color="green">295</FONT>        /**<a name="line.295"></a>
<FONT color="green">296</FONT>         * The maximum number of connections that can remain idle in the<a name="line.296"></a>
<FONT color="green">297</FONT>         * pool, without extra ones being released, or negative for no limit.<a name="line.297"></a>
<FONT color="green">298</FONT>         * If maxIdle is set too low on heavily loaded systems it is possible you<a name="line.298"></a>
<FONT color="green">299</FONT>         * will see connections being closed and almost immediately new connections<a name="line.299"></a>
<FONT color="green">300</FONT>         * being opened. This is a result of the active threads momentarily closing<a name="line.300"></a>
<FONT color="green">301</FONT>         * connections faster than they are opening them, causing the number of idle<a name="line.301"></a>
<FONT color="green">302</FONT>         * connections to rise above maxIdle. The best value for maxIdle for heavily<a name="line.302"></a>
<FONT color="green">303</FONT>         * loaded system will vary but the default is a good starting point.<a name="line.303"></a>
<FONT color="green">304</FONT>         */<a name="line.304"></a>
<FONT color="green">305</FONT>        protected int maxIdle = GenericObjectPool.DEFAULT_MAX_IDLE;<a name="line.305"></a>
<FONT color="green">306</FONT>    <a name="line.306"></a>
<FONT color="green">307</FONT>        /**<a name="line.307"></a>
<FONT color="green">308</FONT>         * &lt;p&gt;Returns the maximum number of connections that can remain idle in the<a name="line.308"></a>
<FONT color="green">309</FONT>         * pool.<a name="line.309"></a>
<FONT color="green">310</FONT>         * &lt;/p&gt;<a name="line.310"></a>
<FONT color="green">311</FONT>         * &lt;p&gt;A negative value indicates that there is no limit&lt;/p&gt;<a name="line.311"></a>
<FONT color="green">312</FONT>         * <a name="line.312"></a>
<FONT color="green">313</FONT>         * @return the maximum number of idle connections<a name="line.313"></a>
<FONT color="green">314</FONT>         */<a name="line.314"></a>
<FONT color="green">315</FONT>        public synchronized int getMaxIdle() {<a name="line.315"></a>
<FONT color="green">316</FONT>            return this.maxIdle;<a name="line.316"></a>
<FONT color="green">317</FONT>        }<a name="line.317"></a>
<FONT color="green">318</FONT>    <a name="line.318"></a>
<FONT color="green">319</FONT>        /**<a name="line.319"></a>
<FONT color="green">320</FONT>         * Sets the maximum number of connections that can remain idle in the<a name="line.320"></a>
<FONT color="green">321</FONT>         * pool.<a name="line.321"></a>
<FONT color="green">322</FONT>         * <a name="line.322"></a>
<FONT color="green">323</FONT>         * @see #getMaxIdle()<a name="line.323"></a>
<FONT color="green">324</FONT>         * @param maxIdle the new value for maxIdle<a name="line.324"></a>
<FONT color="green">325</FONT>         */<a name="line.325"></a>
<FONT color="green">326</FONT>        public synchronized void setMaxIdle(int maxIdle) {<a name="line.326"></a>
<FONT color="green">327</FONT>            this.maxIdle = maxIdle;<a name="line.327"></a>
<FONT color="green">328</FONT>            if (connectionPool != null) {<a name="line.328"></a>
<FONT color="green">329</FONT>                connectionPool.setMaxIdle(maxIdle);<a name="line.329"></a>
<FONT color="green">330</FONT>            }<a name="line.330"></a>
<FONT color="green">331</FONT>        }<a name="line.331"></a>
<FONT color="green">332</FONT>    <a name="line.332"></a>
<FONT color="green">333</FONT>        /**<a name="line.333"></a>
<FONT color="green">334</FONT>         * The minimum number of active connections that can remain idle in the<a name="line.334"></a>
<FONT color="green">335</FONT>         * pool, without extra ones being created, or 0 to create none.<a name="line.335"></a>
<FONT color="green">336</FONT>         */<a name="line.336"></a>
<FONT color="green">337</FONT>        protected int minIdle = GenericObjectPool.DEFAULT_MIN_IDLE;<a name="line.337"></a>
<FONT color="green">338</FONT>    <a name="line.338"></a>
<FONT color="green">339</FONT>        /**<a name="line.339"></a>
<FONT color="green">340</FONT>         * Returns the minimum number of idle connections in the pool<a name="line.340"></a>
<FONT color="green">341</FONT>         * <a name="line.341"></a>
<FONT color="green">342</FONT>         * @return the minimum number of idle connections<a name="line.342"></a>
<FONT color="green">343</FONT>         * @see GenericObjectPool#getMinIdle()<a name="line.343"></a>
<FONT color="green">344</FONT>         */<a name="line.344"></a>
<FONT color="green">345</FONT>        public synchronized int getMinIdle() {<a name="line.345"></a>
<FONT color="green">346</FONT>            return this.minIdle;<a name="line.346"></a>
<FONT color="green">347</FONT>        }<a name="line.347"></a>
<FONT color="green">348</FONT>    <a name="line.348"></a>
<FONT color="green">349</FONT>        /**<a name="line.349"></a>
<FONT color="green">350</FONT>         * Sets the minimum number of idle connections in the pool.<a name="line.350"></a>
<FONT color="green">351</FONT>         * <a name="line.351"></a>
<FONT color="green">352</FONT>         * @param minIdle the new value for minIdle<a name="line.352"></a>
<FONT color="green">353</FONT>         * @see GenericObjectPool#setMinIdle(int)<a name="line.353"></a>
<FONT color="green">354</FONT>         */<a name="line.354"></a>
<FONT color="green">355</FONT>        public synchronized void setMinIdle(int minIdle) {<a name="line.355"></a>
<FONT color="green">356</FONT>           this.minIdle = minIdle;<a name="line.356"></a>
<FONT color="green">357</FONT>           if (connectionPool != null) {<a name="line.357"></a>
<FONT color="green">358</FONT>               connectionPool.setMinIdle(minIdle);<a name="line.358"></a>
<FONT color="green">359</FONT>           }<a name="line.359"></a>
<FONT color="green">360</FONT>        }<a name="line.360"></a>
<FONT color="green">361</FONT>    <a name="line.361"></a>
<FONT color="green">362</FONT>        /**<a name="line.362"></a>
<FONT color="green">363</FONT>         * The initial number of connections that are created when the pool<a name="line.363"></a>
<FONT color="green">364</FONT>         * is started.<a name="line.364"></a>
<FONT color="green">365</FONT>         * <a name="line.365"></a>
<FONT color="green">366</FONT>         * @since 1.2<a name="line.366"></a>
<FONT color="green">367</FONT>         */<a name="line.367"></a>
<FONT color="green">368</FONT>        protected int initialSize = 0;<a name="line.368"></a>
<FONT color="green">369</FONT>        <a name="line.369"></a>
<FONT color="green">370</FONT>        /**<a name="line.370"></a>
<FONT color="green">371</FONT>         * Returns the initial size of the connection pool.<a name="line.371"></a>
<FONT color="green">372</FONT>         * <a name="line.372"></a>
<FONT color="green">373</FONT>         * @return the number of connections created when the pool is initialized<a name="line.373"></a>
<FONT color="green">374</FONT>         */<a name="line.374"></a>
<FONT color="green">375</FONT>        public synchronized int getInitialSize() {<a name="line.375"></a>
<FONT color="green">376</FONT>            return this.initialSize;<a name="line.376"></a>
<FONT color="green">377</FONT>        }<a name="line.377"></a>
<FONT color="green">378</FONT>        <a name="line.378"></a>
<FONT color="green">379</FONT>        /**<a name="line.379"></a>
<FONT color="green">380</FONT>         * &lt;p&gt;Sets the initial size of the connection pool.&lt;/p&gt;<a name="line.380"></a>
<FONT color="green">381</FONT>         * &lt;p&gt;<a name="line.381"></a>
<FONT color="green">382</FONT>         * Note: this method currently has no effect once the pool has been<a name="line.382"></a>
<FONT color="green">383</FONT>         * initialized.  The pool is initialized the first time one of the<a name="line.383"></a>
<FONT color="green">384</FONT>         * following methods is invoked: &lt;code&gt;getConnection, setLogwriter,<a name="line.384"></a>
<FONT color="green">385</FONT>         * setLoginTimeout, getLoginTimeout, getLogWriter.&lt;/code&gt;&lt;/p&gt;<a name="line.385"></a>
<FONT color="green">386</FONT>         * <a name="line.386"></a>
<FONT color="green">387</FONT>         * @param initialSize the number of connections created when the pool<a name="line.387"></a>
<FONT color="green">388</FONT>         * is initialized<a name="line.388"></a>
<FONT color="green">389</FONT>         */<a name="line.389"></a>
<FONT color="green">390</FONT>        public synchronized void setInitialSize(int initialSize) {<a name="line.390"></a>
<FONT color="green">391</FONT>            this.initialSize = initialSize;<a name="line.391"></a>
<FONT color="green">392</FONT>            this.restartNeeded = true;<a name="line.392"></a>
<FONT color="green">393</FONT>        }<a name="line.393"></a>
<FONT color="green">394</FONT>    <a name="line.394"></a>
<FONT color="green">395</FONT>        /**<a name="line.395"></a>
<FONT color="green">396</FONT>         * The maximum number of milliseconds that the pool will wait (when there<a name="line.396"></a>
<FONT color="green">397</FONT>         * are no available connections) for a connection to be returned before<a name="line.397"></a>
<FONT color="green">398</FONT>         * throwing an exception, or &lt;= 0 to wait indefinitely.<a name="line.398"></a>
<FONT color="green">399</FONT>         */<a name="line.399"></a>
<FONT color="green">400</FONT>        protected long maxWait = GenericObjectPool.DEFAULT_MAX_WAIT;<a name="line.400"></a>
<FONT color="green">401</FONT>    <a name="line.401"></a>
<FONT color="green">402</FONT>        /**<a name="line.402"></a>
<FONT color="green">403</FONT>         * &lt;p&gt;Returns the maximum number of milliseconds that the pool will wait<a name="line.403"></a>
<FONT color="green">404</FONT>         * for a connection to be returned before throwing an exception.<a name="line.404"></a>
<FONT color="green">405</FONT>         * &lt;/p&gt;<a name="line.405"></a>
<FONT color="green">406</FONT>         * &lt;p&gt;A value less than or equal to zero means the pool is set to wait<a name="line.406"></a>
<FONT color="green">407</FONT>         * indefinitely.&lt;/p&gt;<a name="line.407"></a>
<FONT color="green">408</FONT>         * <a name="line.408"></a>
<FONT color="green">409</FONT>         * @return the maxWait property value<a name="line.409"></a>
<FONT color="green">410</FONT>         */<a name="line.410"></a>
<FONT color="green">411</FONT>        public synchronized long getMaxWait() {<a name="line.411"></a>
<FONT color="green">412</FONT>            return this.maxWait;<a name="line.412"></a>
<FONT color="green">413</FONT>        }<a name="line.413"></a>
<FONT color="green">414</FONT>    <a name="line.414"></a>
<FONT color="green">415</FONT>        /**<a name="line.415"></a>
<FONT color="green">416</FONT>         * &lt;p&gt;Sets the maxWait property.<a name="line.416"></a>
<FONT color="green">417</FONT>         * &lt;/p&gt;<a name="line.417"></a>
<FONT color="green">418</FONT>         * &lt;p&gt;Use -1 to make the pool wait indefinitely.<a name="line.418"></a>
<FONT color="green">419</FONT>         * &lt;/p&gt;<a name="line.419"></a>
<FONT color="green">420</FONT>         * <a name="line.420"></a>
<FONT color="green">421</FONT>         * @param maxWait the new value for maxWait<a name="line.421"></a>
<FONT color="green">422</FONT>         * @see #getMaxWait()<a name="line.422"></a>
<FONT color="green">423</FONT>         */<a name="line.423"></a>
<FONT color="green">424</FONT>        public synchronized void setMaxWait(long maxWait) {<a name="line.424"></a>
<FONT color="green">425</FONT>            this.maxWait = maxWait;<a name="line.425"></a>
<FONT color="green">426</FONT>            if (connectionPool != null) {<a name="line.426"></a>
<FONT color="green">427</FONT>                connectionPool.setMaxWait(maxWait);<a name="line.427"></a>
<FONT color="green">428</FONT>            }<a name="line.428"></a>
<FONT color="green">429</FONT>        }<a name="line.429"></a>
<FONT color="green">430</FONT>    <a name="line.430"></a>
<FONT color="green">431</FONT>        /**<a name="line.431"></a>
<FONT color="green">432</FONT>         * Prepared statement pooling for this pool. When this property is set to &lt;code&gt;true&lt;/code&gt;<a name="line.432"></a>
<FONT color="green">433</FONT>         * both PreparedStatements and CallableStatements are pooled.<a name="line.433"></a>
<FONT color="green">434</FONT>         */<a name="line.434"></a>
<FONT color="green">435</FONT>        protected boolean poolPreparedStatements = false;<a name="line.435"></a>
<FONT color="green">436</FONT>        <a name="line.436"></a>
<FONT color="green">437</FONT>        /**<a name="line.437"></a>
<FONT color="green">438</FONT>         * Returns true if we are pooling statements.<a name="line.438"></a>
<FONT color="green">439</FONT>         * <a name="line.439"></a>
<FONT color="green">440</FONT>         * @return true if prepared and callable statements are pooled<a name="line.440"></a>
<FONT color="green">441</FONT>         */<a name="line.441"></a>
<FONT color="green">442</FONT>        public synchronized boolean isPoolPreparedStatements() {<a name="line.442"></a>
<FONT color="green">443</FONT>            return this.poolPreparedStatements;<a name="line.443"></a>
<FONT color="green">444</FONT>        }<a name="line.444"></a>
<FONT color="green">445</FONT>    <a name="line.445"></a>
<FONT color="green">446</FONT>        /**<a name="line.446"></a>
<FONT color="green">447</FONT>         * &lt;p&gt;Sets whether to pool statements or not.&lt;/p&gt;<a name="line.447"></a>
<FONT color="green">448</FONT>         * &lt;p&gt;<a name="line.448"></a>
<FONT color="green">449</FONT>         * Note: this method currently has no effect once the pool has been<a name="line.449"></a>
<FONT color="green">450</FONT>         * initialized.  The pool is initialized the first time one of the<a name="line.450"></a>
<FONT color="green">451</FONT>         * following methods is invoked: &lt;code&gt;getConnection, setLogwriter,<a name="line.451"></a>
<FONT color="green">452</FONT>         * setLoginTimeout, getLoginTimeout, getLogWriter.&lt;/code&gt;&lt;/p&gt;<a name="line.452"></a>
<FONT color="green">453</FONT>         * <a name="line.453"></a>
<FONT color="green">454</FONT>         * @param poolingStatements pooling on or off<a name="line.454"></a>
<FONT color="green">455</FONT>         */<a name="line.455"></a>
<FONT color="green">456</FONT>        public synchronized void setPoolPreparedStatements(boolean poolingStatements) {<a name="line.456"></a>
<FONT color="green">457</FONT>            this.poolPreparedStatements = poolingStatements;<a name="line.457"></a>
<FONT color="green">458</FONT>            this.restartNeeded = true;<a name="line.458"></a>
<FONT color="green">459</FONT>        }<a name="line.459"></a>
<FONT color="green">460</FONT>    <a name="line.460"></a>
<FONT color="green">461</FONT>        /**<a name="line.461"></a>
<FONT color="green">462</FONT>         * &lt;p&gt;The maximum number of open statements that can be allocated from<a name="line.462"></a>
<FONT color="green">463</FONT>         * the statement pool at the same time, or non-positive for no limit.  Since <a name="line.463"></a>
<FONT color="green">464</FONT>         * a connection usually only uses one or two statements at a time, this is<a name="line.464"></a>
<FONT color="green">465</FONT>         * mostly used to help detect resource leaks.&lt;/p&gt;<a name="line.465"></a>
<FONT color="green">466</FONT>         * <a name="line.466"></a>
<FONT color="green">467</FONT>         * &lt;p&gt;Note: As of version 1.3, CallableStatements (those produced by {@link Connection#prepareCall})<a name="line.467"></a>
<FONT color="green">468</FONT>         * are pooled along with PreparedStatements (produced by {@link Connection#prepareStatement})<a name="line.468"></a>
<FONT color="green">469</FONT>         * and &lt;code&gt;maxOpenPreparedStatements&lt;/code&gt; limits the total number of prepared or callable statements<a name="line.469"></a>
<FONT color="green">470</FONT>         * that may be in use at a given time.&lt;/p&gt;<a name="line.470"></a>
<FONT color="green">471</FONT>         */<a name="line.471"></a>
<FONT color="green">472</FONT>        protected int maxOpenPreparedStatements = GenericKeyedObjectPool.DEFAULT_MAX_TOTAL;<a name="line.472"></a>
<FONT color="green">473</FONT>    <a name="line.473"></a>
<FONT color="green">474</FONT>        /**<a name="line.474"></a>
<FONT color="green">475</FONT>         * Gets the value of the {@link #maxOpenPreparedStatements} property.<a name="line.475"></a>
<FONT color="green">476</FONT>         * <a name="line.476"></a>
<FONT color="green">477</FONT>         * @return the maximum number of open statements<a name="line.477"></a>
<FONT color="green">478</FONT>         * @see #maxOpenPreparedStatements<a name="line.478"></a>
<FONT color="green">479</FONT>         */<a name="line.479"></a>
<FONT color="green">480</FONT>        public synchronized int getMaxOpenPreparedStatements() {<a name="line.480"></a>
<FONT color="green">481</FONT>            return this.maxOpenPreparedStatements;<a name="line.481"></a>
<FONT color="green">482</FONT>        }<a name="line.482"></a>
<FONT color="green">483</FONT>    <a name="line.483"></a>
<FONT color="green">484</FONT>        /** <a name="line.484"></a>
<FONT color="green">485</FONT>         * &lt;p&gt;Sets the value of the {@link #maxOpenPreparedStatements}<a name="line.485"></a>
<FONT color="green">486</FONT>         * property.&lt;/p&gt;<a name="line.486"></a>
<FONT color="green">487</FONT>         * &lt;p&gt;<a name="line.487"></a>
<FONT color="green">488</FONT>         * Note: this method currently has no effect once the pool has been<a name="line.488"></a>
<FONT color="green">489</FONT>         * initialized.  The pool is initialized the first time one of the<a name="line.489"></a>
<FONT color="green">490</FONT>         * following methods is invoked: &lt;code&gt;getConnection, setLogwriter,<a name="line.490"></a>
<FONT color="green">491</FONT>         * setLoginTimeout, getLoginTimeout, getLogWriter.&lt;/code&gt;&lt;/p&gt;<a name="line.491"></a>
<FONT color="green">492</FONT>         * <a name="line.492"></a>
<FONT color="green">493</FONT>         * @param maxOpenStatements the new maximum number of prepared statements<a name="line.493"></a>
<FONT color="green">494</FONT>         * @see #maxOpenPreparedStatements<a name="line.494"></a>
<FONT color="green">495</FONT>         */<a name="line.495"></a>
<FONT color="green">496</FONT>        public synchronized void setMaxOpenPreparedStatements(int maxOpenStatements) {<a name="line.496"></a>
<FONT color="green">497</FONT>            this.maxOpenPreparedStatements = maxOpenStatements;<a name="line.497"></a>
<FONT color="green">498</FONT>            this.restartNeeded = true;<a name="line.498"></a>
<FONT color="green">499</FONT>        }<a name="line.499"></a>
<FONT color="green">500</FONT>    <a name="line.500"></a>
<FONT color="green">501</FONT>        /**<a name="line.501"></a>
<FONT color="green">502</FONT>         * The indication of whether objects will be validated before being<a name="line.502"></a>
<FONT color="green">503</FONT>         * borrowed from the pool.  If the object fails to validate, it will be<a name="line.503"></a>
<FONT color="green">504</FONT>         * dropped from the pool, and we will attempt to borrow another.<a name="line.504"></a>
<FONT color="green">505</FONT>         */<a name="line.505"></a>
<FONT color="green">506</FONT>        protected boolean testOnBorrow = true;<a name="line.506"></a>
<FONT color="green">507</FONT>    <a name="line.507"></a>
<FONT color="green">508</FONT>        /**<a name="line.508"></a>
<FONT color="green">509</FONT>         * Returns the {@link #testOnBorrow} property.<a name="line.509"></a>
<FONT color="green">510</FONT>         * <a name="line.510"></a>
<FONT color="green">511</FONT>         * @return true if objects are validated before being borrowed from the<a name="line.511"></a>
<FONT color="green">512</FONT>         * pool<a name="line.512"></a>
<FONT color="green">513</FONT>         * <a name="line.513"></a>
<FONT color="green">514</FONT>         * @see #testOnBorrow<a name="line.514"></a>
<FONT color="green">515</FONT>         */<a name="line.515"></a>
<FONT color="green">516</FONT>        public synchronized boolean getTestOnBorrow() {<a name="line.516"></a>
<FONT color="green">517</FONT>            return this.testOnBorrow;<a name="line.517"></a>
<FONT color="green">518</FONT>        }<a name="line.518"></a>
<FONT color="green">519</FONT>    <a name="line.519"></a>
<FONT color="green">520</FONT>        /**<a name="line.520"></a>
<FONT color="green">521</FONT>         * Sets the {@link #testOnBorrow} property. This property determines<a name="line.521"></a>
<FONT color="green">522</FONT>         * whether or not the pool will validate objects before they are borrowed<a name="line.522"></a>
<FONT color="green">523</FONT>         * from the pool. For a &lt;code&gt;true&lt;/code&gt; value to have any effect, the <a name="line.523"></a>
<FONT color="green">524</FONT>         * &lt;code&gt;validationQuery&lt;/code&gt; property must be set to a non-null string.<a name="line.524"></a>
<FONT color="green">525</FONT>         * <a name="line.525"></a>
<FONT color="green">526</FONT>         * @param testOnBorrow new value for testOnBorrow property<a name="line.526"></a>
<FONT color="green">527</FONT>         */<a name="line.527"></a>
<FONT color="green">528</FONT>        public synchronized void setTestOnBorrow(boolean testOnBorrow) {<a name="line.528"></a>
<FONT color="green">529</FONT>            this.testOnBorrow = testOnBorrow;<a name="line.529"></a>
<FONT color="green">530</FONT>            if (connectionPool != null) {<a name="line.530"></a>
<FONT color="green">531</FONT>                connectionPool.setTestOnBorrow(testOnBorrow);<a name="line.531"></a>
<FONT color="green">532</FONT>            }<a name="line.532"></a>
<FONT color="green">533</FONT>        }<a name="line.533"></a>
<FONT color="green">534</FONT>    <a name="line.534"></a>
<FONT color="green">535</FONT>        /**<a name="line.535"></a>
<FONT color="green">536</FONT>         * The indication of whether objects will be validated before being<a name="line.536"></a>
<FONT color="green">537</FONT>         * returned to the pool.<a name="line.537"></a>
<FONT color="green">538</FONT>         */<a name="line.538"></a>
<FONT color="green">539</FONT>        protected boolean testOnReturn = false;<a name="line.539"></a>
<FONT color="green">540</FONT>    <a name="line.540"></a>
<FONT color="green">541</FONT>        /**<a name="line.541"></a>
<FONT color="green">542</FONT>         * Returns the value of the {@link #testOnReturn} property.<a name="line.542"></a>
<FONT color="green">543</FONT>         * <a name="line.543"></a>
<FONT color="green">544</FONT>         * @return true if objects are validated before being returned to the<a name="line.544"></a>
<FONT color="green">545</FONT>         * pool<a name="line.545"></a>
<FONT color="green">546</FONT>         * @see #testOnReturn<a name="line.546"></a>
<FONT color="green">547</FONT>         */<a name="line.547"></a>
<FONT color="green">548</FONT>        public synchronized boolean getTestOnReturn() {<a name="line.548"></a>
<FONT color="green">549</FONT>            return this.testOnReturn;<a name="line.549"></a>
<FONT color="green">550</FONT>        }<a name="line.550"></a>
<FONT color="green">551</FONT>    <a name="line.551"></a>
<FONT color="green">552</FONT>        /**<a name="line.552"></a>
<FONT color="green">553</FONT>         * Sets the &lt;code&gt;testOnReturn&lt;/code&gt; property. This property determines<a name="line.553"></a>
<FONT color="green">554</FONT>         * whether or not the pool will validate objects before they are returned<a name="line.554"></a>
<FONT color="green">555</FONT>         * to the pool. For a &lt;code&gt;true&lt;/code&gt; value to have any effect, the <a name="line.555"></a>
<FONT color="green">556</FONT>         * &lt;code&gt;validationQuery&lt;/code&gt; property must be set to a non-null string.<a name="line.556"></a>
<FONT color="green">557</FONT>         * <a name="line.557"></a>
<FONT color="green">558</FONT>         * @param testOnReturn new value for testOnReturn property<a name="line.558"></a>
<FONT color="green">559</FONT>         */<a name="line.559"></a>
<FONT color="green">560</FONT>        public synchronized void setTestOnReturn(boolean testOnReturn) {<a name="line.560"></a>
<FONT color="green">561</FONT>            this.testOnReturn = testOnReturn;<a name="line.561"></a>
<FONT color="green">562</FONT>            if (connectionPool != null) {<a name="line.562"></a>
<FONT color="green">563</FONT>                connectionPool.setTestOnReturn(testOnReturn);<a name="line.563"></a>
<FONT color="green">564</FONT>            }<a name="line.564"></a>
<FONT color="green">565</FONT>        }<a name="line.565"></a>
<FONT color="green">566</FONT>    <a name="line.566"></a>
<FONT color="green">567</FONT>        /**<a name="line.567"></a>
<FONT color="green">568</FONT>         * The number of milliseconds to sleep between runs of the idle object<a name="line.568"></a>
<FONT color="green">569</FONT>         * evictor thread.  When non-positive, no idle object evictor thread will<a name="line.569"></a>
<FONT color="green">570</FONT>         * be run.<a name="line.570"></a>
<FONT color="green">571</FONT>         */<a name="line.571"></a>
<FONT color="green">572</FONT>        protected long timeBetweenEvictionRunsMillis =<a name="line.572"></a>
<FONT color="green">573</FONT>            GenericObjectPool.DEFAULT_TIME_BETWEEN_EVICTION_RUNS_MILLIS;<a name="line.573"></a>
<FONT color="green">574</FONT>            <a name="line.574"></a>
<FONT color="green">575</FONT>        /**<a name="line.575"></a>
<FONT color="green">576</FONT>         * Returns the value of the {@link #timeBetweenEvictionRunsMillis}<a name="line.576"></a>
<FONT color="green">577</FONT>         * property.<a name="line.577"></a>
<FONT color="green">578</FONT>         * <a name="line.578"></a>
<FONT color="green">579</FONT>         * @return the time (in miliseconds) between evictor runs<a name="line.579"></a>
<FONT color="green">580</FONT>         * @see #timeBetweenEvictionRunsMillis<a name="line.580"></a>
<FONT color="green">581</FONT>         */<a name="line.581"></a>
<FONT color="green">582</FONT>        public synchronized long getTimeBetweenEvictionRunsMillis() {<a name="line.582"></a>
<FONT color="green">583</FONT>            return this.timeBetweenEvictionRunsMillis;<a name="line.583"></a>
<FONT color="green">584</FONT>        }<a name="line.584"></a>
<FONT color="green">585</FONT>    <a name="line.585"></a>
<FONT color="green">586</FONT>        /**<a name="line.586"></a>
<FONT color="green">587</FONT>         * Sets the {@link #timeBetweenEvictionRunsMillis} property.<a name="line.587"></a>
<FONT color="green">588</FONT>         * <a name="line.588"></a>
<FONT color="green">589</FONT>         * @param timeBetweenEvictionRunsMillis the new time between evictor runs<a name="line.589"></a>
<FONT color="green">590</FONT>         * @see #timeBetweenEvictionRunsMillis<a name="line.590"></a>
<FONT color="green">591</FONT>         */<a name="line.591"></a>
<FONT color="green">592</FONT>        public synchronized void setTimeBetweenEvictionRunsMillis(long timeBetweenEvictionRunsMillis) {<a name="line.592"></a>
<FONT color="green">593</FONT>            this.timeBetweenEvictionRunsMillis = timeBetweenEvictionRunsMillis;<a name="line.593"></a>
<FONT color="green">594</FONT>            if (connectionPool != null) {<a name="line.594"></a>
<FONT color="green">595</FONT>                connectionPool.setTimeBetweenEvictionRunsMillis(timeBetweenEvictionRunsMillis);<a name="line.595"></a>
<FONT color="green">596</FONT>            }<a name="line.596"></a>
<FONT color="green">597</FONT>        }<a name="line.597"></a>
<FONT color="green">598</FONT>    <a name="line.598"></a>
<FONT color="green">599</FONT>        /**<a name="line.599"></a>
<FONT color="green">600</FONT>         * The number of objects to examine during each run of the idle object<a name="line.600"></a>
<FONT color="green">601</FONT>         * evictor thread (if any).<a name="line.601"></a>
<FONT color="green">602</FONT>         */<a name="line.602"></a>
<FONT color="green">603</FONT>        protected int numTestsPerEvictionRun =<a name="line.603"></a>
<FONT color="green">604</FONT>            GenericObjectPool.DEFAULT_NUM_TESTS_PER_EVICTION_RUN;<a name="line.604"></a>
<FONT color="green">605</FONT>    <a name="line.605"></a>
<FONT color="green">606</FONT>        /**<a name="line.606"></a>
<FONT color="green">607</FONT>         * Returns the value of the {@link #numTestsPerEvictionRun} property.<a name="line.607"></a>
<FONT color="green">608</FONT>         * <a name="line.608"></a>
<FONT color="green">609</FONT>         * @return the number of objects to examine during idle object evictor<a name="line.609"></a>
<FONT color="green">610</FONT>         * runs<a name="line.610"></a>
<FONT color="green">611</FONT>         * @see #numTestsPerEvictionRun<a name="line.611"></a>
<FONT color="green">612</FONT>         */<a name="line.612"></a>
<FONT color="green">613</FONT>        public synchronized int getNumTestsPerEvictionRun() {<a name="line.613"></a>
<FONT color="green">614</FONT>            return this.numTestsPerEvictionRun;<a name="line.614"></a>
<FONT color="green">615</FONT>        }<a name="line.615"></a>
<FONT color="green">616</FONT>    <a name="line.616"></a>
<FONT color="green">617</FONT>        /**<a name="line.617"></a>
<FONT color="green">618</FONT>         * Sets the value of the {@link #numTestsPerEvictionRun} property.<a name="line.618"></a>
<FONT color="green">619</FONT>         * <a name="line.619"></a>
<FONT color="green">620</FONT>         * @param numTestsPerEvictionRun the new {@link #numTestsPerEvictionRun} <a name="line.620"></a>
<FONT color="green">621</FONT>         * value<a name="line.621"></a>
<FONT color="green">622</FONT>         * @see #numTestsPerEvictionRun<a name="line.622"></a>
<FONT color="green">623</FONT>         */<a name="line.623"></a>
<FONT color="green">624</FONT>        public synchronized void setNumTestsPerEvictionRun(int numTestsPerEvictionRun) {<a name="line.624"></a>
<FONT color="green">625</FONT>            this.numTestsPerEvictionRun = numTestsPerEvictionRun;<a name="line.625"></a>
<FONT color="green">626</FONT>            if (connectionPool != null) {<a name="line.626"></a>
<FONT color="green">627</FONT>                connectionPool.setNumTestsPerEvictionRun(numTestsPerEvictionRun);<a name="line.627"></a>
<FONT color="green">628</FONT>            }<a name="line.628"></a>
<FONT color="green">629</FONT>        }<a name="line.629"></a>
<FONT color="green">630</FONT>    <a name="line.630"></a>
<FONT color="green">631</FONT>        /**<a name="line.631"></a>
<FONT color="green">632</FONT>         * The minimum amount of time an object may sit idle in the pool before it<a name="line.632"></a>
<FONT color="green">633</FONT>         * is eligable for eviction by the idle object evictor (if any).<a name="line.633"></a>
<FONT color="green">634</FONT>         */<a name="line.634"></a>
<FONT color="green">635</FONT>        protected long minEvictableIdleTimeMillis =<a name="line.635"></a>
<FONT color="green">636</FONT>            GenericObjectPool.DEFAULT_MIN_EVICTABLE_IDLE_TIME_MILLIS;<a name="line.636"></a>
<FONT color="green">637</FONT>    <a name="line.637"></a>
<FONT color="green">638</FONT>        /**<a name="line.638"></a>
<FONT color="green">639</FONT>         * Returns the {@link #minEvictableIdleTimeMillis} property.<a name="line.639"></a>
<FONT color="green">640</FONT>         * <a name="line.640"></a>
<FONT color="green">641</FONT>         * @return the value of the {@link #minEvictableIdleTimeMillis} property<a name="line.641"></a>
<FONT color="green">642</FONT>         * @see #minEvictableIdleTimeMillis<a name="line.642"></a>
<FONT color="green">643</FONT>         */<a name="line.643"></a>
<FONT color="green">644</FONT>        public synchronized long getMinEvictableIdleTimeMillis() {<a name="line.644"></a>
<FONT color="green">645</FONT>            return this.minEvictableIdleTimeMillis;<a name="line.645"></a>
<FONT color="green">646</FONT>        }<a name="line.646"></a>
<FONT color="green">647</FONT>    <a name="line.647"></a>
<FONT color="green">648</FONT>        /**<a name="line.648"></a>
<FONT color="green">649</FONT>         * Sets the {@link #minEvictableIdleTimeMillis} property.<a name="line.649"></a>
<FONT color="green">650</FONT>         * <a name="line.650"></a>
<FONT color="green">651</FONT>         * @param minEvictableIdleTimeMillis the minimum amount of time an object<a name="line.651"></a>
<FONT color="green">652</FONT>         * may sit idle in the pool <a name="line.652"></a>
<FONT color="green">653</FONT>         * @see #minEvictableIdleTimeMillis<a name="line.653"></a>
<FONT color="green">654</FONT>         */<a name="line.654"></a>
<FONT color="green">655</FONT>        public synchronized void setMinEvictableIdleTimeMillis(long minEvictableIdleTimeMillis) {<a name="line.655"></a>
<FONT color="green">656</FONT>            this.minEvictableIdleTimeMillis = minEvictableIdleTimeMillis;<a name="line.656"></a>
<FONT color="green">657</FONT>            if (connectionPool != null) {<a name="line.657"></a>
<FONT color="green">658</FONT>                connectionPool.setMinEvictableIdleTimeMillis(minEvictableIdleTimeMillis);<a name="line.658"></a>
<FONT color="green">659</FONT>            }<a name="line.659"></a>
<FONT color="green">660</FONT>        }<a name="line.660"></a>
<FONT color="green">661</FONT>    <a name="line.661"></a>
<FONT color="green">662</FONT>        /**<a name="line.662"></a>
<FONT color="green">663</FONT>         * The indication of whether objects will be validated by the idle object<a name="line.663"></a>
<FONT color="green">664</FONT>         * evictor (if any).  If an object fails to validate, it will be dropped<a name="line.664"></a>
<FONT color="green">665</FONT>         * from the pool.<a name="line.665"></a>
<FONT color="green">666</FONT>         */<a name="line.666"></a>
<FONT color="green">667</FONT>        protected boolean testWhileIdle = false;<a name="line.667"></a>
<FONT color="green">668</FONT>    <a name="line.668"></a>
<FONT color="green">669</FONT>        /**<a name="line.669"></a>
<FONT color="green">670</FONT>         * Returns the value of the {@link #testWhileIdle} property.<a name="line.670"></a>
<FONT color="green">671</FONT>         * <a name="line.671"></a>
<FONT color="green">672</FONT>         * @return true if objects examined by the idle object evictor are<a name="line.672"></a>
<FONT color="green">673</FONT>         * validated<a name="line.673"></a>
<FONT color="green">674</FONT>         * @see #testWhileIdle<a name="line.674"></a>
<FONT color="green">675</FONT>         */<a name="line.675"></a>
<FONT color="green">676</FONT>        public synchronized boolean getTestWhileIdle() {<a name="line.676"></a>
<FONT color="green">677</FONT>            return this.testWhileIdle;<a name="line.677"></a>
<FONT color="green">678</FONT>        }<a name="line.678"></a>
<FONT color="green">679</FONT>    <a name="line.679"></a>
<FONT color="green">680</FONT>        /**<a name="line.680"></a>
<FONT color="green">681</FONT>         * Sets the &lt;code&gt;testWhileIdle&lt;/code&gt; property. This property determines<a name="line.681"></a>
<FONT color="green">682</FONT>         * whether or not the idle object evictor will validate connections.  For a<a name="line.682"></a>
<FONT color="green">683</FONT>         * &lt;code&gt;true&lt;/code&gt; value to have any effect, the <a name="line.683"></a>
<FONT color="green">684</FONT>         * &lt;code&gt;validationQuery&lt;/code&gt; property must be set to a non-null string.<a name="line.684"></a>
<FONT color="green">685</FONT>         * <a name="line.685"></a>
<FONT color="green">686</FONT>         * @param testWhileIdle new value for testWhileIdle property<a name="line.686"></a>
<FONT color="green">687</FONT>         */<a name="line.687"></a>
<FONT color="green">688</FONT>        public synchronized void setTestWhileIdle(boolean testWhileIdle) {<a name="line.688"></a>
<FONT color="green">689</FONT>            this.testWhileIdle = testWhileIdle;<a name="line.689"></a>
<FONT color="green">690</FONT>            if (connectionPool != null) {<a name="line.690"></a>
<FONT color="green">691</FONT>                connectionPool.setTestWhileIdle(testWhileIdle);<a name="line.691"></a>
<FONT color="green">692</FONT>            }<a name="line.692"></a>
<FONT color="green">693</FONT>        }<a name="line.693"></a>
<FONT color="green">694</FONT>    <a name="line.694"></a>
<FONT color="green">695</FONT>        /**<a name="line.695"></a>
<FONT color="green">696</FONT>         * [Read Only] The current number of active connections that have been<a name="line.696"></a>
<FONT color="green">697</FONT>         * allocated from this data source.<a name="line.697"></a>
<FONT color="green">698</FONT>         * <a name="line.698"></a>
<FONT color="green">699</FONT>         * @return the current number of active connections<a name="line.699"></a>
<FONT color="green">700</FONT>         */<a name="line.700"></a>
<FONT color="green">701</FONT>        public synchronized int getNumActive() {<a name="line.701"></a>
<FONT color="green">702</FONT>            if (connectionPool != null) {<a name="line.702"></a>
<FONT color="green">703</FONT>                return connectionPool.getNumActive();<a name="line.703"></a>
<FONT color="green">704</FONT>            } else {<a name="line.704"></a>
<FONT color="green">705</FONT>                return 0;<a name="line.705"></a>
<FONT color="green">706</FONT>            }<a name="line.706"></a>
<FONT color="green">707</FONT>        }<a name="line.707"></a>
<FONT color="green">708</FONT>    <a name="line.708"></a>
<FONT color="green">709</FONT>    <a name="line.709"></a>
<FONT color="green">710</FONT>        /**<a name="line.710"></a>
<FONT color="green">711</FONT>         * [Read Only] The current number of idle connections that are waiting<a name="line.711"></a>
<FONT color="green">712</FONT>         * to be allocated from this data source.<a name="line.712"></a>
<FONT color="green">713</FONT>         * <a name="line.713"></a>
<FONT color="green">714</FONT>         * @return the current number of idle connections<a name="line.714"></a>
<FONT color="green">715</FONT>         */<a name="line.715"></a>
<FONT color="green">716</FONT>        public synchronized int getNumIdle() {<a name="line.716"></a>
<FONT color="green">717</FONT>            if (connectionPool != null) {<a name="line.717"></a>
<FONT color="green">718</FONT>                return connectionPool.getNumIdle();<a name="line.718"></a>
<FONT color="green">719</FONT>            } else {<a name="line.719"></a>
<FONT color="green">720</FONT>                return 0;<a name="line.720"></a>
<FONT color="green">721</FONT>            }<a name="line.721"></a>
<FONT color="green">722</FONT>        }<a name="line.722"></a>
<FONT color="green">723</FONT>    <a name="line.723"></a>
<FONT color="green">724</FONT>        /**<a name="line.724"></a>
<FONT color="green">725</FONT>         * The connection password to be passed to our JDBC driver to establish<a name="line.725"></a>
<FONT color="green">726</FONT>         * a connection.<a name="line.726"></a>
<FONT color="green">727</FONT>         */<a name="line.727"></a>
<FONT color="green">728</FONT>        protected volatile String password = null;<a name="line.728"></a>
<FONT color="green">729</FONT>    <a name="line.729"></a>
<FONT color="green">730</FONT>        /**<a name="line.730"></a>
<FONT color="green">731</FONT>         * Returns the password passed to the JDBC driver to establish connections.<a name="line.731"></a>
<FONT color="green">732</FONT>         * <a name="line.732"></a>
<FONT color="green">733</FONT>         * @return the connection password<a name="line.733"></a>
<FONT color="green">734</FONT>         */<a name="line.734"></a>
<FONT color="green">735</FONT>        public String getPassword() {<a name="line.735"></a>
<FONT color="green">736</FONT>            return this.password;<a name="line.736"></a>
<FONT color="green">737</FONT>        }<a name="line.737"></a>
<FONT color="green">738</FONT>    <a name="line.738"></a>
<FONT color="green">739</FONT>        /** <a name="line.739"></a>
<FONT color="green">740</FONT>         * &lt;p&gt;Sets the {@link #password}.&lt;/p&gt;<a name="line.740"></a>
<FONT color="green">741</FONT>         * &lt;p&gt;<a name="line.741"></a>
<FONT color="green">742</FONT>         * Note: this method currently has no effect once the pool has been<a name="line.742"></a>
<FONT color="green">743</FONT>         * initialized.  The pool is initialized the first time one of the<a name="line.743"></a>
<FONT color="green">744</FONT>         * following methods is invoked: &lt;code&gt;getConnection, setLogwriter,<a name="line.744"></a>
<FONT color="green">745</FONT>         * setLoginTimeout, getLoginTimeout, getLogWriter.&lt;/code&gt;&lt;/p&gt;<a name="line.745"></a>
<FONT color="green">746</FONT>         * <a name="line.746"></a>
<FONT color="green">747</FONT>         * @param password new value for the password<a name="line.747"></a>
<FONT color="green">748</FONT>         */<a name="line.748"></a>
<FONT color="green">749</FONT>        public void setPassword(String password) {<a name="line.749"></a>
<FONT color="green">750</FONT>            this.password = password;<a name="line.750"></a>
<FONT color="green">751</FONT>            this.restartNeeded = true;<a name="line.751"></a>
<FONT color="green">752</FONT>        }<a name="line.752"></a>
<FONT color="green">753</FONT>    <a name="line.753"></a>
<FONT color="green">754</FONT>        /**<a name="line.754"></a>
<FONT color="green">755</FONT>         * The connection URL to be passed to our JDBC driver to establish<a name="line.755"></a>
<FONT color="green">756</FONT>         * a connection.<a name="line.756"></a>
<FONT color="green">757</FONT>         */<a name="line.757"></a>
<FONT color="green">758</FONT>        protected String url = null;<a name="line.758"></a>
<FONT color="green">759</FONT>    <a name="line.759"></a>
<FONT color="green">760</FONT>        /**<a name="line.760"></a>
<FONT color="green">761</FONT>         * Returns the JDBC connection {@link #url} property.<a name="line.761"></a>
<FONT color="green">762</FONT>         * <a name="line.762"></a>
<FONT color="green">763</FONT>         * @return the {@link #url} passed to the JDBC driver to establish<a name="line.763"></a>
<FONT color="green">764</FONT>         * connections<a name="line.764"></a>
<FONT color="green">765</FONT>         */<a name="line.765"></a>
<FONT color="green">766</FONT>        public synchronized String getUrl() {<a name="line.766"></a>
<FONT color="green">767</FONT>            return this.url;<a name="line.767"></a>
<FONT color="green">768</FONT>        }<a name="line.768"></a>
<FONT color="green">769</FONT>    <a name="line.769"></a>
<FONT color="green">770</FONT>        /** <a name="line.770"></a>
<FONT color="green">771</FONT>         * &lt;p&gt;Sets the {@link #url}.&lt;/p&gt;<a name="line.771"></a>
<FONT color="green">772</FONT>         * &lt;p&gt;<a name="line.772"></a>
<FONT color="green">773</FONT>         * Note: this method currently has no effect once the pool has been<a name="line.773"></a>
<FONT color="green">774</FONT>         * initialized.  The pool is initialized the first time one of the<a name="line.774"></a>
<FONT color="green">775</FONT>         * following methods is invoked: &lt;code&gt;getConnection, setLogwriter,<a name="line.775"></a>
<FONT color="green">776</FONT>         * setLoginTimeout, getLoginTimeout, getLogWriter.&lt;/code&gt;&lt;/p&gt;<a name="line.776"></a>
<FONT color="green">777</FONT>         * <a name="line.777"></a>
<FONT color="green">778</FONT>         * @param url the new value for the JDBC connection url<a name="line.778"></a>
<FONT color="green">779</FONT>         */<a name="line.779"></a>
<FONT color="green">780</FONT>        public synchronized void setUrl(String url) {<a name="line.780"></a>
<FONT color="green">781</FONT>            this.url = url;<a name="line.781"></a>
<FONT color="green">782</FONT>            this.restartNeeded = true;<a name="line.782"></a>
<FONT color="green">783</FONT>        }<a name="line.783"></a>
<FONT color="green">784</FONT>    <a name="line.784"></a>
<FONT color="green">785</FONT>        /**<a name="line.785"></a>
<FONT color="green">786</FONT>         * The connection username to be passed to our JDBC driver to<a name="line.786"></a>
<FONT color="green">787</FONT>         * establish a connection.<a name="line.787"></a>
<FONT color="green">788</FONT>         */<a name="line.788"></a>
<FONT color="green">789</FONT>        protected String username = null;<a name="line.789"></a>
<FONT color="green">790</FONT>    <a name="line.790"></a>
<FONT color="green">791</FONT>        /**<a name="line.791"></a>
<FONT color="green">792</FONT>         * Returns the JDBC connection {@link #username} property.<a name="line.792"></a>
<FONT color="green">793</FONT>         * <a name="line.793"></a>
<FONT color="green">794</FONT>         * @return the {@link #username} passed to the JDBC driver to establish<a name="line.794"></a>
<FONT color="green">795</FONT>         * connections<a name="line.795"></a>
<FONT color="green">796</FONT>         */<a name="line.796"></a>
<FONT color="green">797</FONT>        public String getUsername() {<a name="line.797"></a>
<FONT color="green">798</FONT>            return this.username;<a name="line.798"></a>
<FONT color="green">799</FONT>        }<a name="line.799"></a>
<FONT color="green">800</FONT>    <a name="line.800"></a>
<FONT color="green">801</FONT>        /** <a name="line.801"></a>
<FONT color="green">802</FONT>         * &lt;p&gt;Sets the {@link #username}.&lt;/p&gt;<a name="line.802"></a>
<FONT color="green">803</FONT>         * &lt;p&gt;<a name="line.803"></a>
<FONT color="green">804</FONT>         * Note: this method currently has no effect once the pool has been<a name="line.804"></a>
<FONT color="green">805</FONT>         * initialized.  The pool is initialized the first time one of the<a name="line.805"></a>
<FONT color="green">806</FONT>         * following methods is invoked: &lt;code&gt;getConnection, setLogwriter,<a name="line.806"></a>
<FONT color="green">807</FONT>         * setLoginTimeout, getLoginTimeout, getLogWriter.&lt;/code&gt;&lt;/p&gt;<a name="line.807"></a>
<FONT color="green">808</FONT>         * <a name="line.808"></a>
<FONT color="green">809</FONT>         * @param username the new value for the JDBC connection username<a name="line.809"></a>
<FONT color="green">810</FONT>         */<a name="line.810"></a>
<FONT color="green">811</FONT>        public void setUsername(String username) {<a name="line.811"></a>
<FONT color="green">812</FONT>            this.username = username;<a name="line.812"></a>
<FONT color="green">813</FONT>            this.restartNeeded = true;<a name="line.813"></a>
<FONT color="green">814</FONT>        }<a name="line.814"></a>
<FONT color="green">815</FONT>    <a name="line.815"></a>
<FONT color="green">816</FONT>        /**<a name="line.816"></a>
<FONT color="green">817</FONT>         * The SQL query that will be used to validate connections from this pool<a name="line.817"></a>
<FONT color="green">818</FONT>         * before returning them to the caller.  If specified, this query<a name="line.818"></a>
<FONT color="green">819</FONT>         * &lt;strong&gt;MUST&lt;/strong&gt; be an SQL SELECT statement that returns at least<a name="line.819"></a>
<FONT color="green">820</FONT>         * one row.<a name="line.820"></a>
<FONT color="green">821</FONT>         */<a name="line.821"></a>
<FONT color="green">822</FONT>        protected volatile String validationQuery = null;<a name="line.822"></a>
<FONT color="green">823</FONT>    <a name="line.823"></a>
<FONT color="green">824</FONT>        /**<a name="line.824"></a>
<FONT color="green">825</FONT>         * Returns the validation query used to validate connections before<a name="line.825"></a>
<FONT color="green">826</FONT>         * returning them.<a name="line.826"></a>
<FONT color="green">827</FONT>         * <a name="line.827"></a>
<FONT color="green">828</FONT>         * @return the SQL validation query<a name="line.828"></a>
<FONT color="green">829</FONT>         * @see #validationQuery<a name="line.829"></a>
<FONT color="green">830</FONT>         */<a name="line.830"></a>
<FONT color="green">831</FONT>        public String getValidationQuery() {<a name="line.831"></a>
<FONT color="green">832</FONT>            return this.validationQuery;<a name="line.832"></a>
<FONT color="green">833</FONT>        }<a name="line.833"></a>
<FONT color="green">834</FONT>    <a name="line.834"></a>
<FONT color="green">835</FONT>        /** <a name="line.835"></a>
<FONT color="green">836</FONT>         * &lt;p&gt;Sets the {@link #validationQuery}.&lt;/p&gt;<a name="line.836"></a>
<FONT color="green">837</FONT>         * &lt;p&gt;<a name="line.837"></a>
<FONT color="green">838</FONT>         * Note: this method currently has no effect once the pool has been<a name="line.838"></a>
<FONT color="green">839</FONT>         * initialized.  The pool is initialized the first time one of the<a name="line.839"></a>
<FONT color="green">840</FONT>         * following methods is invoked: &lt;code&gt;getConnection, setLogwriter,<a name="line.840"></a>
<FONT color="green">841</FONT>         * setLoginTimeout, getLoginTimeout, getLogWriter.&lt;/code&gt;&lt;/p&gt;<a name="line.841"></a>
<FONT color="green">842</FONT>         * <a name="line.842"></a>
<FONT color="green">843</FONT>         * @param validationQuery the new value for the validation query<a name="line.843"></a>
<FONT color="green">844</FONT>         */<a name="line.844"></a>
<FONT color="green">845</FONT>        public void setValidationQuery(String validationQuery) {<a name="line.845"></a>
<FONT color="green">846</FONT>            if ((validationQuery != null) &amp;&amp; (validationQuery.trim().length() &gt; 0)) {<a name="line.846"></a>
<FONT color="green">847</FONT>                this.validationQuery = validationQuery;<a name="line.847"></a>
<FONT color="green">848</FONT>            } else {<a name="line.848"></a>
<FONT color="green">849</FONT>                this.validationQuery = null;<a name="line.849"></a>
<FONT color="green">850</FONT>            }<a name="line.850"></a>
<FONT color="green">851</FONT>            this.restartNeeded = true;<a name="line.851"></a>
<FONT color="green">852</FONT>        }<a name="line.852"></a>
<FONT color="green">853</FONT>        <a name="line.853"></a>
<FONT color="green">854</FONT>        /**<a name="line.854"></a>
<FONT color="green">855</FONT>         * Timeout in seconds before connection validation queries fail. <a name="line.855"></a>
<FONT color="green">856</FONT>         * <a name="line.856"></a>
<FONT color="green">857</FONT>         * @since 1.3<a name="line.857"></a>
<FONT color="green">858</FONT>         */<a name="line.858"></a>
<FONT color="green">859</FONT>        protected volatile int validationQueryTimeout = -1;<a name="line.859"></a>
<FONT color="green">860</FONT>        <a name="line.860"></a>
<FONT color="green">861</FONT>        /**<a name="line.861"></a>
<FONT color="green">862</FONT>         * Returns the validation query timeout.<a name="line.862"></a>
<FONT color="green">863</FONT>         * <a name="line.863"></a>
<FONT color="green">864</FONT>         * @return the timeout in seconds before connection validation queries fail.<a name="line.864"></a>
<FONT color="green">865</FONT>         * @since 1.3<a name="line.865"></a>
<FONT color="green">866</FONT>         */<a name="line.866"></a>
<FONT color="green">867</FONT>        public int getValidationQueryTimeout() {<a name="line.867"></a>
<FONT color="green">868</FONT>            return validationQueryTimeout;<a name="line.868"></a>
<FONT color="green">869</FONT>        }<a name="line.869"></a>
<FONT color="green">870</FONT>        <a name="line.870"></a>
<FONT color="green">871</FONT>        /**<a name="line.871"></a>
<FONT color="green">872</FONT>         * Sets the validation query timeout, the amount of time, in seconds, that<a name="line.872"></a>
<FONT color="green">873</FONT>         * connection validation will wait for a response from the database when<a name="line.873"></a>
<FONT color="green">874</FONT>         * executing a validation query.  Use a value less than or equal to 0 for<a name="line.874"></a>
<FONT color="green">875</FONT>         * no timeout.<a name="line.875"></a>
<FONT color="green">876</FONT>         * &lt;p&gt;<a name="line.876"></a>
<FONT color="green">877</FONT>         * Note: this method currently has no effect once the pool has been<a name="line.877"></a>
<FONT color="green">878</FONT>         * initialized.  The pool is initialized the first time one of the<a name="line.878"></a>
<FONT color="green">879</FONT>         * following methods is invoked: &lt;code&gt;getConnection, setLogwriter,<a name="line.879"></a>
<FONT color="green">880</FONT>         * setLoginTimeout, getLoginTimeout, getLogWriter.&lt;/code&gt;&lt;/p&gt;<a name="line.880"></a>
<FONT color="green">881</FONT>         * <a name="line.881"></a>
<FONT color="green">882</FONT>         * @param timeout new validation query timeout value in seconds<a name="line.882"></a>
<FONT color="green">883</FONT>         * @since 1.3<a name="line.883"></a>
<FONT color="green">884</FONT>         */<a name="line.884"></a>
<FONT color="green">885</FONT>        public void setValidationQueryTimeout(int timeout) {<a name="line.885"></a>
<FONT color="green">886</FONT>            this.validationQueryTimeout = timeout;<a name="line.886"></a>
<FONT color="green">887</FONT>            restartNeeded = true;<a name="line.887"></a>
<FONT color="green">888</FONT>        }<a name="line.888"></a>
<FONT color="green">889</FONT>        <a name="line.889"></a>
<FONT color="green">890</FONT>        /**<a name="line.890"></a>
<FONT color="green">891</FONT>         * These SQL statements run once after a Connection is created.<a name="line.891"></a>
<FONT color="green">892</FONT>         * &lt;p&gt;<a name="line.892"></a>
<FONT color="green">893</FONT>         * This property can be used for example to run ALTER SESSION SET<a name="line.893"></a>
<FONT color="green">894</FONT>         * NLS_SORT=XCYECH in an Oracle Database only once after connection<a name="line.894"></a>
<FONT color="green">895</FONT>         * creation.<a name="line.895"></a>
<FONT color="green">896</FONT>         * &lt;/p&gt;<a name="line.896"></a>
<FONT color="green">897</FONT>         * <a name="line.897"></a>
<FONT color="green">898</FONT>         * @since 1.3<a name="line.898"></a>
<FONT color="green">899</FONT>         */<a name="line.899"></a>
<FONT color="green">900</FONT>        protected volatile List connectionInitSqls;<a name="line.900"></a>
<FONT color="green">901</FONT>    <a name="line.901"></a>
<FONT color="green">902</FONT>        /**<a name="line.902"></a>
<FONT color="green">903</FONT>         * Returns the list of SQL statements executed when a physical connection<a name="line.903"></a>
<FONT color="green">904</FONT>         * is first created. Returns an empty list if there are no initialization<a name="line.904"></a>
<FONT color="green">905</FONT>         * statements configured.<a name="line.905"></a>
<FONT color="green">906</FONT>         * <a name="line.906"></a>
<FONT color="green">907</FONT>         * @return initialization SQL statements<a name="line.907"></a>
<FONT color="green">908</FONT>         * @since 1.3<a name="line.908"></a>
<FONT color="green">909</FONT>         */<a name="line.909"></a>
<FONT color="green">910</FONT>        public Collection getConnectionInitSqls() {<a name="line.910"></a>
<FONT color="green">911</FONT>            Collection result = connectionInitSqls; <a name="line.911"></a>
<FONT color="green">912</FONT>            if (result == null) {<a name="line.912"></a>
<FONT color="green">913</FONT>                return Collections.EMPTY_LIST;<a name="line.913"></a>
<FONT color="green">914</FONT>            }<a name="line.914"></a>
<FONT color="green">915</FONT>            return result;<a name="line.915"></a>
<FONT color="green">916</FONT>        }<a name="line.916"></a>
<FONT color="green">917</FONT>    <a name="line.917"></a>
<FONT color="green">918</FONT>        /**<a name="line.918"></a>
<FONT color="green">919</FONT>         * Sets the list of SQL statements to be executed when a physical<a name="line.919"></a>
<FONT color="green">920</FONT>         * connection is first created.<a name="line.920"></a>
<FONT color="green">921</FONT>         * &lt;p&gt;<a name="line.921"></a>
<FONT color="green">922</FONT>         * Note: this method currently has no effect once the pool has been<a name="line.922"></a>
<FONT color="green">923</FONT>         * initialized.  The pool is initialized the first time one of the<a name="line.923"></a>
<FONT color="green">924</FONT>         * following methods is invoked: &lt;code&gt;getConnection, setLogwriter,<a name="line.924"></a>
<FONT color="green">925</FONT>         * setLoginTimeout, getLoginTimeout, getLogWriter.&lt;/code&gt;&lt;/p&gt;<a name="line.925"></a>
<FONT color="green">926</FONT>         * <a name="line.926"></a>
<FONT color="green">927</FONT>         * @param connectionInitSqls Collection of SQL statements to execute<a name="line.927"></a>
<FONT color="green">928</FONT>         * on connection creation<a name="line.928"></a>
<FONT color="green">929</FONT>         */<a name="line.929"></a>
<FONT color="green">930</FONT>        public void setConnectionInitSqls(Collection connectionInitSqls) {<a name="line.930"></a>
<FONT color="green">931</FONT>            if ((connectionInitSqls != null) &amp;&amp; (connectionInitSqls.size() &gt; 0)) {<a name="line.931"></a>
<FONT color="green">932</FONT>                ArrayList newVal = null;<a name="line.932"></a>
<FONT color="green">933</FONT>                for (Iterator iterator = connectionInitSqls.iterator();<a name="line.933"></a>
<FONT color="green">934</FONT>                iterator.hasNext();) {<a name="line.934"></a>
<FONT color="green">935</FONT>                    Object o = iterator.next();<a name="line.935"></a>
<FONT color="green">936</FONT>                    if (o != null) {<a name="line.936"></a>
<FONT color="green">937</FONT>                        String s = o.toString();<a name="line.937"></a>
<FONT color="green">938</FONT>                        if (s.trim().length() &gt; 0) {<a name="line.938"></a>
<FONT color="green">939</FONT>                            if (newVal == null) {<a name="line.939"></a>
<FONT color="green">940</FONT>                                newVal = new ArrayList();<a name="line.940"></a>
<FONT color="green">941</FONT>                            }<a name="line.941"></a>
<FONT color="green">942</FONT>                            newVal.add(s);<a name="line.942"></a>
<FONT color="green">943</FONT>                        }<a name="line.943"></a>
<FONT color="green">944</FONT>                    }<a name="line.944"></a>
<FONT color="green">945</FONT>                }<a name="line.945"></a>
<FONT color="green">946</FONT>                this.connectionInitSqls = newVal;<a name="line.946"></a>
<FONT color="green">947</FONT>            } else {<a name="line.947"></a>
<FONT color="green">948</FONT>                this.connectionInitSqls = null;<a name="line.948"></a>
<FONT color="green">949</FONT>            }<a name="line.949"></a>
<FONT color="green">950</FONT>            this.restartNeeded = true;<a name="line.950"></a>
<FONT color="green">951</FONT>        }<a name="line.951"></a>
<FONT color="green">952</FONT>    <a name="line.952"></a>
<FONT color="green">953</FONT>    <a name="line.953"></a>
<FONT color="green">954</FONT>        /** <a name="line.954"></a>
<FONT color="green">955</FONT>         * Controls access to the underlying connection.<a name="line.955"></a>
<FONT color="green">956</FONT>         */<a name="line.956"></a>
<FONT color="green">957</FONT>        private boolean accessToUnderlyingConnectionAllowed = false; <a name="line.957"></a>
<FONT color="green">958</FONT>    <a name="line.958"></a>
<FONT color="green">959</FONT>        /**<a name="line.959"></a>
<FONT color="green">960</FONT>         * Returns the value of the accessToUnderlyingConnectionAllowed property.<a name="line.960"></a>
<FONT color="green">961</FONT>         * <a name="line.961"></a>
<FONT color="green">962</FONT>         * @return true if access to the underlying connection is allowed, false<a name="line.962"></a>
<FONT color="green">963</FONT>         * otherwise.<a name="line.963"></a>
<FONT color="green">964</FONT>         */<a name="line.964"></a>
<FONT color="green">965</FONT>        public synchronized boolean isAccessToUnderlyingConnectionAllowed() {<a name="line.965"></a>
<FONT color="green">966</FONT>            return this.accessToUnderlyingConnectionAllowed;<a name="line.966"></a>
<FONT color="green">967</FONT>        }<a name="line.967"></a>
<FONT color="green">968</FONT>    <a name="line.968"></a>
<FONT color="green">969</FONT>        /**<a name="line.969"></a>
<FONT color="green">970</FONT>         * &lt;p&gt;Sets the value of the accessToUnderlyingConnectionAllowed property.<a name="line.970"></a>
<FONT color="green">971</FONT>         * It controls if the PoolGuard allows access to the underlying connection.<a name="line.971"></a>
<FONT color="green">972</FONT>         * (Default: false)&lt;/p&gt;<a name="line.972"></a>
<FONT color="green">973</FONT>         * &lt;p&gt;<a name="line.973"></a>
<FONT color="green">974</FONT>         * Note: this method currently has no effect once the pool has been<a name="line.974"></a>
<FONT color="green">975</FONT>         * initialized.  The pool is initialized the first time one of the<a name="line.975"></a>
<FONT color="green">976</FONT>         * following methods is invoked: &lt;code&gt;getConnection, setLogwriter,<a name="line.976"></a>
<FONT color="green">977</FONT>         * setLoginTimeout, getLoginTimeout, getLogWriter.&lt;/code&gt;&lt;/p&gt;<a name="line.977"></a>
<FONT color="green">978</FONT>         * <a name="line.978"></a>
<FONT color="green">979</FONT>         * @param allow Access to the underlying connection is granted when true.<a name="line.979"></a>
<FONT color="green">980</FONT>         */<a name="line.980"></a>
<FONT color="green">981</FONT>        public synchronized void setAccessToUnderlyingConnectionAllowed(boolean allow) {<a name="line.981"></a>
<FONT color="green">982</FONT>            this.accessToUnderlyingConnectionAllowed = allow;<a name="line.982"></a>
<FONT color="green">983</FONT>            this.restartNeeded = true;<a name="line.983"></a>
<FONT color="green">984</FONT>        }<a name="line.984"></a>
<FONT color="green">985</FONT>    <a name="line.985"></a>
<FONT color="green">986</FONT>        // ----------------------------------------------------- Instance Variables<a name="line.986"></a>
<FONT color="green">987</FONT>    <a name="line.987"></a>
<FONT color="green">988</FONT>        // TODO: review &amp; make isRestartNeeded() public, restartNeeded protected<a name="line.988"></a>
<FONT color="green">989</FONT>    <a name="line.989"></a>
<FONT color="green">990</FONT>        /**<a name="line.990"></a>
<FONT color="green">991</FONT>         * A property setter has been invoked that will require the connection<a name="line.991"></a>
<FONT color="green">992</FONT>         * pool to be re-initialized. Currently, restart is not triggered, so<a name="line.992"></a>
<FONT color="green">993</FONT>         * this property has no effect.<a name="line.993"></a>
<FONT color="green">994</FONT>         */<a name="line.994"></a>
<FONT color="green">995</FONT>        private volatile boolean restartNeeded = false;<a name="line.995"></a>
<FONT color="green">996</FONT>        <a name="line.996"></a>
<FONT color="green">997</FONT>        /**<a name="line.997"></a>
<FONT color="green">998</FONT>         * Returns whether or not a restart is needed. <a name="line.998"></a>
<FONT color="green">999</FONT>         *  <a name="line.999"></a>
<FONT color="green">1000</FONT>         * Note: restart is not currently triggered by property changes.<a name="line.1000"></a>
<FONT color="green">1001</FONT>         * <a name="line.1001"></a>
<FONT color="green">1002</FONT>         * @return true if a restart is needed<a name="line.1002"></a>
<FONT color="green">1003</FONT>         */<a name="line.1003"></a>
<FONT color="green">1004</FONT>        private boolean isRestartNeeded() {<a name="line.1004"></a>
<FONT color="green">1005</FONT>            return restartNeeded;<a name="line.1005"></a>
<FONT color="green">1006</FONT>        }<a name="line.1006"></a>
<FONT color="green">1007</FONT>    <a name="line.1007"></a>
<FONT color="green">1008</FONT>        /**<a name="line.1008"></a>
<FONT color="green">1009</FONT>         * The object pool that internally manages our connections.<a name="line.1009"></a>
<FONT color="green">1010</FONT>         */<a name="line.1010"></a>
<FONT color="green">1011</FONT>        protected volatile GenericObjectPool connectionPool = null;<a name="line.1011"></a>
<FONT color="green">1012</FONT>        <a name="line.1012"></a>
<FONT color="green">1013</FONT>        /**<a name="line.1013"></a>
<FONT color="green">1014</FONT>         * The connection properties that will be sent to our JDBC driver when<a name="line.1014"></a>
<FONT color="green">1015</FONT>         * establishing new connections.  &lt;strong&gt;NOTE&lt;/strong&gt; - The "user" and<a name="line.1015"></a>
<FONT color="green">1016</FONT>         * "password" properties will be passed explicitly, so they do not need<a name="line.1016"></a>
<FONT color="green">1017</FONT>         * to be included here.<a name="line.1017"></a>
<FONT color="green">1018</FONT>         */<a name="line.1018"></a>
<FONT color="green">1019</FONT>        protected Properties connectionProperties = new Properties();<a name="line.1019"></a>
<FONT color="green">1020</FONT>    <a name="line.1020"></a>
<FONT color="green">1021</FONT>        /**<a name="line.1021"></a>
<FONT color="green">1022</FONT>         * The data source we will use to manage connections.  This object should<a name="line.1022"></a>
<FONT color="green">1023</FONT>         * be acquired &lt;strong&gt;ONLY&lt;/strong&gt; by calls to the<a name="line.1023"></a>
<FONT color="green">1024</FONT>         * &lt;code&gt;createDataSource()&lt;/code&gt; method.<a name="line.1024"></a>
<FONT color="green">1025</FONT>         */<a name="line.1025"></a>
<FONT color="green">1026</FONT>        protected volatile DataSource dataSource = null;<a name="line.1026"></a>
<FONT color="green">1027</FONT>    <a name="line.1027"></a>
<FONT color="green">1028</FONT>        /**<a name="line.1028"></a>
<FONT color="green">1029</FONT>         * The PrintWriter to which log messages should be directed.<a name="line.1029"></a>
<FONT color="green">1030</FONT>         */<a name="line.1030"></a>
<FONT color="green">1031</FONT>        protected PrintWriter logWriter = new PrintWriter(System.out);<a name="line.1031"></a>
<FONT color="green">1032</FONT>    <a name="line.1032"></a>
<FONT color="green">1033</FONT>    <a name="line.1033"></a>
<FONT color="green">1034</FONT>        // ----------------------------------------------------- DataSource Methods<a name="line.1034"></a>
<FONT color="green">1035</FONT>    <a name="line.1035"></a>
<FONT color="green">1036</FONT>    <a name="line.1036"></a>
<FONT color="green">1037</FONT>        /**<a name="line.1037"></a>
<FONT color="green">1038</FONT>         * Create (if necessary) and return a connection to the database.<a name="line.1038"></a>
<FONT color="green">1039</FONT>         *<a name="line.1039"></a>
<FONT color="green">1040</FONT>         * @throws SQLException if a database access error occurs<a name="line.1040"></a>
<FONT color="green">1041</FONT>         * @return a database connection<a name="line.1041"></a>
<FONT color="green">1042</FONT>         */<a name="line.1042"></a>
<FONT color="green">1043</FONT>        public Connection getConnection() throws SQLException {<a name="line.1043"></a>
<FONT color="green">1044</FONT>            return createDataSource().getConnection();<a name="line.1044"></a>
<FONT color="green">1045</FONT>        }<a name="line.1045"></a>
<FONT color="green">1046</FONT>    <a name="line.1046"></a>
<FONT color="green">1047</FONT>    <a name="line.1047"></a>
<FONT color="green">1048</FONT>        /**<a name="line.1048"></a>
<FONT color="green">1049</FONT>         * &lt;strong&gt;BasicDataSource does NOT support this method. &lt;/strong&gt;<a name="line.1049"></a>
<FONT color="green">1050</FONT>         *<a name="line.1050"></a>
<FONT color="green">1051</FONT>         * @param user Database user on whose behalf the Connection<a name="line.1051"></a>
<FONT color="green">1052</FONT>         *   is being made<a name="line.1052"></a>
<FONT color="green">1053</FONT>         * @param pass The database user's password<a name="line.1053"></a>
<FONT color="green">1054</FONT>         *<a name="line.1054"></a>
<FONT color="green">1055</FONT>         * @throws UnsupportedOperationException<a name="line.1055"></a>
<FONT color="green">1056</FONT>         * @throws SQLException if a database access error occurs<a name="line.1056"></a>
<FONT color="green">1057</FONT>         * @return nothing - always throws UnsupportedOperationException<a name="line.1057"></a>
<FONT color="green">1058</FONT>         */<a name="line.1058"></a>
<FONT color="green">1059</FONT>        public Connection getConnection(String user, String pass) throws SQLException {<a name="line.1059"></a>
<FONT color="green">1060</FONT>            // This method isn't supported by the PoolingDataSource returned by<a name="line.1060"></a>
<FONT color="green">1061</FONT>            // the createDataSource<a name="line.1061"></a>
<FONT color="green">1062</FONT>            throw new UnsupportedOperationException("Not supported by BasicDataSource");<a name="line.1062"></a>
<FONT color="green">1063</FONT>            // return createDataSource().getConnection(username, password);<a name="line.1063"></a>
<FONT color="green">1064</FONT>        }<a name="line.1064"></a>
<FONT color="green">1065</FONT>    <a name="line.1065"></a>
<FONT color="green">1066</FONT>    <a name="line.1066"></a>
<FONT color="green">1067</FONT>        /**<a name="line.1067"></a>
<FONT color="green">1068</FONT>         * &lt;strong&gt;BasicDataSource does NOT support this method. &lt;/strong&gt;<a name="line.1068"></a>
<FONT color="green">1069</FONT>         *<a name="line.1069"></a>
<FONT color="green">1070</FONT>         * &lt;p&gt;Returns the login timeout (in seconds) for connecting to the database.<a name="line.1070"></a>
<FONT color="green">1071</FONT>         * &lt;/p&gt;<a name="line.1071"></a>
<FONT color="green">1072</FONT>         * &lt;p&gt;Calls {@link #createDataSource()}, so has the side effect<a name="line.1072"></a>
<FONT color="green">1073</FONT>         * of initializing the connection pool.&lt;/p&gt;<a name="line.1073"></a>
<FONT color="green">1074</FONT>         *<a name="line.1074"></a>
<FONT color="green">1075</FONT>         * @throws SQLException if a database access error occurs<a name="line.1075"></a>
<FONT color="green">1076</FONT>         * @throws UnsupportedOperationException If the DataSource implementation<a name="line.1076"></a>
<FONT color="green">1077</FONT>         *   does not support the login timeout feature.<a name="line.1077"></a>
<FONT color="green">1078</FONT>         * @return login timeout in seconds<a name="line.1078"></a>
<FONT color="green">1079</FONT>         */<a name="line.1079"></a>
<FONT color="green">1080</FONT>        public int getLoginTimeout() throws SQLException {<a name="line.1080"></a>
<FONT color="green">1081</FONT>            // This method isn't supported by the PoolingDataSource returned by<a name="line.1081"></a>
<FONT color="green">1082</FONT>            // the createDataSource<a name="line.1082"></a>
<FONT color="green">1083</FONT>            throw new UnsupportedOperationException("Not supported by BasicDataSource");<a name="line.1083"></a>
<FONT color="green">1084</FONT>            //return createDataSource().getLoginTimeout();<a name="line.1084"></a>
<FONT color="green">1085</FONT>        }<a name="line.1085"></a>
<FONT color="green">1086</FONT>    <a name="line.1086"></a>
<FONT color="green">1087</FONT>    <a name="line.1087"></a>
<FONT color="green">1088</FONT>        /**<a name="line.1088"></a>
<FONT color="green">1089</FONT>         * &lt;p&gt;Returns the log writer being used by this data source.&lt;/p&gt;<a name="line.1089"></a>
<FONT color="green">1090</FONT>         * &lt;p&gt;<a name="line.1090"></a>
<FONT color="green">1091</FONT>         * Calls {@link #createDataSource()}, so has the side effect<a name="line.1091"></a>
<FONT color="green">1092</FONT>         * of initializing the connection pool.&lt;/p&gt;<a name="line.1092"></a>
<FONT color="green">1093</FONT>         *<a name="line.1093"></a>
<FONT color="green">1094</FONT>         * @throws SQLException if a database access error occurs<a name="line.1094"></a>
<FONT color="green">1095</FONT>         * @return log writer in use<a name="line.1095"></a>
<FONT color="green">1096</FONT>         */<a name="line.1096"></a>
<FONT color="green">1097</FONT>        public PrintWriter getLogWriter() throws SQLException {<a name="line.1097"></a>
<FONT color="green">1098</FONT>            return createDataSource().getLogWriter();<a name="line.1098"></a>
<FONT color="green">1099</FONT>        }<a name="line.1099"></a>
<FONT color="green">1100</FONT>    <a name="line.1100"></a>
<FONT color="green">1101</FONT>    <a name="line.1101"></a>
<FONT color="green">1102</FONT>        /**<a name="line.1102"></a>
<FONT color="green">1103</FONT>         * &lt;strong&gt;BasicDataSource does NOT support this method. &lt;/strong&gt;<a name="line.1103"></a>
<FONT color="green">1104</FONT>         *<a name="line.1104"></a>
<FONT color="green">1105</FONT>         * &lt;p&gt;Set the login timeout (in seconds) for connecting to the<a name="line.1105"></a>
<FONT color="green">1106</FONT>         * database.&lt;/p&gt;<a name="line.1106"></a>
<FONT color="green">1107</FONT>         * &lt;p&gt;<a name="line.1107"></a>
<FONT color="green">1108</FONT>         * Calls {@link #createDataSource()}, so has the side effect<a name="line.1108"></a>
<FONT color="green">1109</FONT>         * of initializing the connection pool.&lt;/p&gt;<a name="line.1109"></a>
<FONT color="green">1110</FONT>         *<a name="line.1110"></a>
<FONT color="green">1111</FONT>         * @param loginTimeout The new login timeout, or zero for no timeout<a name="line.1111"></a>
<FONT color="green">1112</FONT>         * @throws UnsupportedOperationException If the DataSource implementation<a name="line.1112"></a>
<FONT color="green">1113</FONT>         *   does not support the login timeout feature.<a name="line.1113"></a>
<FONT color="green">1114</FONT>         * @throws SQLException if a database access error occurs<a name="line.1114"></a>
<FONT color="green">1115</FONT>         */<a name="line.1115"></a>
<FONT color="green">1116</FONT>        public void setLoginTimeout(int loginTimeout) throws SQLException {<a name="line.1116"></a>
<FONT color="green">1117</FONT>            // This method isn't supported by the PoolingDataSource returned by<a name="line.1117"></a>
<FONT color="green">1118</FONT>            // the createDataSource<a name="line.1118"></a>
<FONT color="green">1119</FONT>            throw new UnsupportedOperationException("Not supported by BasicDataSource");<a name="line.1119"></a>
<FONT color="green">1120</FONT>            //createDataSource().setLoginTimeout(loginTimeout);<a name="line.1120"></a>
<FONT color="green">1121</FONT>        }<a name="line.1121"></a>
<FONT color="green">1122</FONT>    <a name="line.1122"></a>
<FONT color="green">1123</FONT>    <a name="line.1123"></a>
<FONT color="green">1124</FONT>        /**<a name="line.1124"></a>
<FONT color="green">1125</FONT>         * &lt;p&gt;Sets the log writer being used by this data source.&lt;/p&gt;<a name="line.1125"></a>
<FONT color="green">1126</FONT>         * &lt;p&gt;<a name="line.1126"></a>
<FONT color="green">1127</FONT>         * Calls {@link #createDataSource()}, so has the side effect<a name="line.1127"></a>
<FONT color="green">1128</FONT>         * of initializing the connection pool.&lt;/p&gt;<a name="line.1128"></a>
<FONT color="green">1129</FONT>         *<a name="line.1129"></a>
<FONT color="green">1130</FONT>         * @param logWriter The new log writer<a name="line.1130"></a>
<FONT color="green">1131</FONT>         * @throws SQLException if a database access error occurs<a name="line.1131"></a>
<FONT color="green">1132</FONT>         */<a name="line.1132"></a>
<FONT color="green">1133</FONT>        public void setLogWriter(PrintWriter logWriter) throws SQLException {<a name="line.1133"></a>
<FONT color="green">1134</FONT>            createDataSource().setLogWriter(logWriter);<a name="line.1134"></a>
<FONT color="green">1135</FONT>            this.logWriter = logWriter;<a name="line.1135"></a>
<FONT color="green">1136</FONT>        }<a name="line.1136"></a>
<FONT color="green">1137</FONT>    <a name="line.1137"></a>
<FONT color="green">1138</FONT>        private AbandonedConfig abandonedConfig;<a name="line.1138"></a>
<FONT color="green">1139</FONT>    <a name="line.1139"></a>
<FONT color="green">1140</FONT>        /**                       <a name="line.1140"></a>
<FONT color="green">1141</FONT>         * Flag to remove abandoned connections if they exceed the<a name="line.1141"></a>
<FONT color="green">1142</FONT>         * removeAbandonedTimout.<a name="line.1142"></a>
<FONT color="green">1143</FONT>         *<a name="line.1143"></a>
<FONT color="green">1144</FONT>         * Set to true or false, default false.<a name="line.1144"></a>
<FONT color="green">1145</FONT>         * If set to true a connection is considered abandoned and eligible<a name="line.1145"></a>
<FONT color="green">1146</FONT>         * for removal if it has been idle longer than the removeAbandonedTimeout.<a name="line.1146"></a>
<FONT color="green">1147</FONT>         * Setting this to true can recover db connections from poorly written    <a name="line.1147"></a>
<FONT color="green">1148</FONT>         * applications which fail to close a connection.<a name="line.1148"></a>
<FONT color="green">1149</FONT>         * &lt;p&gt;<a name="line.1149"></a>
<FONT color="green">1150</FONT>         * Abandonded connections are identified and removed when <a name="line.1150"></a>
<FONT color="green">1151</FONT>         * {@link #getConnection()} is invoked and the following conditions hold<a name="line.1151"></a>
<FONT color="green">1152</FONT>         * &lt;ul&gt;&lt;li&gt;{@link #getRemoveAbandoned()} = true &lt;/li&gt;<a name="line.1152"></a>
<FONT color="green">1153</FONT>         *     &lt;li&gt;{@link #getNumActive()} &gt; {@link #getMaxActive()} - 3 &lt;/li&gt;<a name="line.1153"></a>
<FONT color="green">1154</FONT>         *     &lt;li&gt;{@link #getNumIdle()} &lt; 2 &lt;/li&gt;&lt;/ul&gt;&lt;/p&gt;<a name="line.1154"></a>
<FONT color="green">1155</FONT>         */                                                                   <a name="line.1155"></a>
<FONT color="green">1156</FONT>        public boolean getRemoveAbandoned() {   <a name="line.1156"></a>
<FONT color="green">1157</FONT>            if (abandonedConfig != null) {<a name="line.1157"></a>
<FONT color="green">1158</FONT>                return abandonedConfig.getRemoveAbandoned();<a name="line.1158"></a>
<FONT color="green">1159</FONT>            }<a name="line.1159"></a>
<FONT color="green">1160</FONT>            return false;<a name="line.1160"></a>
<FONT color="green">1161</FONT>        }                                    <a name="line.1161"></a>
<FONT color="green">1162</FONT>                                     <a name="line.1162"></a>
<FONT color="green">1163</FONT>        /**<a name="line.1163"></a>
<FONT color="green">1164</FONT>         * @param removeAbandoned new removeAbandoned property value<a name="line.1164"></a>
<FONT color="green">1165</FONT>         * @see #getRemoveAbandoned()<a name="line.1165"></a>
<FONT color="green">1166</FONT>         */<a name="line.1166"></a>
<FONT color="green">1167</FONT>        public void setRemoveAbandoned(boolean removeAbandoned) {<a name="line.1167"></a>
<FONT color="green">1168</FONT>            if (abandonedConfig == null) {<a name="line.1168"></a>
<FONT color="green">1169</FONT>                abandonedConfig = new AbandonedConfig();<a name="line.1169"></a>
<FONT color="green">1170</FONT>            }<a name="line.1170"></a>
<FONT color="green">1171</FONT>            abandonedConfig.setRemoveAbandoned(removeAbandoned);<a name="line.1171"></a>
<FONT color="green">1172</FONT>            this.restartNeeded = true;<a name="line.1172"></a>
<FONT color="green">1173</FONT>        }                                                        <a name="line.1173"></a>
<FONT color="green">1174</FONT>                                                   <a name="line.1174"></a>
<FONT color="green">1175</FONT>        /**<a name="line.1175"></a>
<FONT color="green">1176</FONT>         * Timeout in seconds before an abandoned connection can be removed.<a name="line.1176"></a>
<FONT color="green">1177</FONT>         *<a name="line.1177"></a>
<FONT color="green">1178</FONT>         * Defaults to 300 seconds. <a name="line.1178"></a>
<FONT color="green">1179</FONT>         * @return abandoned connection timeout        <a name="line.1179"></a>
<FONT color="green">1180</FONT>         */                                                                 <a name="line.1180"></a>
<FONT color="green">1181</FONT>        public int getRemoveAbandonedTimeout() { <a name="line.1181"></a>
<FONT color="green">1182</FONT>            if (abandonedConfig != null) {<a name="line.1182"></a>
<FONT color="green">1183</FONT>                return abandonedConfig.getRemoveAbandonedTimeout();<a name="line.1183"></a>
<FONT color="green">1184</FONT>            }<a name="line.1184"></a>
<FONT color="green">1185</FONT>            return 300;<a name="line.1185"></a>
<FONT color="green">1186</FONT>        }                                        <a name="line.1186"></a>
<FONT color="green">1187</FONT>    <a name="line.1187"></a>
<FONT color="green">1188</FONT>        /**<a name="line.1188"></a>
<FONT color="green">1189</FONT>         * @param removeAbandonedTimeout new removeAbandonedTimeout value<a name="line.1189"></a>
<FONT color="green">1190</FONT>         */               <a name="line.1190"></a>
<FONT color="green">1191</FONT>        public void setRemoveAbandonedTimeout(int removeAbandonedTimeout) {<a name="line.1191"></a>
<FONT color="green">1192</FONT>            if (abandonedConfig == null) {<a name="line.1192"></a>
<FONT color="green">1193</FONT>                abandonedConfig = new AbandonedConfig();<a name="line.1193"></a>
<FONT color="green">1194</FONT>            }<a name="line.1194"></a>
<FONT color="green">1195</FONT>            abandonedConfig.setRemoveAbandonedTimeout(removeAbandonedTimeout);<a name="line.1195"></a>
<FONT color="green">1196</FONT>            this.restartNeeded = true;<a name="line.1196"></a>
<FONT color="green">1197</FONT>        }                                                                  <a name="line.1197"></a>
<FONT color="green">1198</FONT>                                                                 <a name="line.1198"></a>
<FONT color="green">1199</FONT>        /**<a name="line.1199"></a>
<FONT color="green">1200</FONT>         * &lt;p&gt;Flag to log stack traces for application code which abandoned<a name="line.1200"></a>
<FONT color="green">1201</FONT>         * a Statement or Connection.<a name="line.1201"></a>
<FONT color="green">1202</FONT>         * &lt;/p&gt;<a name="line.1202"></a>
<FONT color="green">1203</FONT>         * &lt;p&gt;Defaults to false.                <a name="line.1203"></a>
<FONT color="green">1204</FONT>         * &lt;/p&gt;                                                            <a name="line.1204"></a>
<FONT color="green">1205</FONT>         * &lt;p&gt;Logging of abandoned Statements and Connections adds overhead<a name="line.1205"></a>
<FONT color="green">1206</FONT>         * for every Connection open or new Statement because a stack   <a name="line.1206"></a>
<FONT color="green">1207</FONT>         * trace has to be generated. &lt;/p&gt;<a name="line.1207"></a>
<FONT color="green">1208</FONT>         */                                                          <a name="line.1208"></a>
<FONT color="green">1209</FONT>        public boolean getLogAbandoned() {   <a name="line.1209"></a>
<FONT color="green">1210</FONT>            if (abandonedConfig != null) {<a name="line.1210"></a>
<FONT color="green">1211</FONT>                return abandonedConfig.getLogAbandoned();<a name="line.1211"></a>
<FONT color="green">1212</FONT>            }<a name="line.1212"></a>
<FONT color="green">1213</FONT>            return false;<a name="line.1213"></a>
<FONT color="green">1214</FONT>        }                                 <a name="line.1214"></a>
<FONT color="green">1215</FONT>    <a name="line.1215"></a>
<FONT color="green">1216</FONT>        /**<a name="line.1216"></a>
<FONT color="green">1217</FONT>         * @param logAbandoned new logAbandoned property value<a name="line.1217"></a>
<FONT color="green">1218</FONT>         */<a name="line.1218"></a>
<FONT color="green">1219</FONT>        public void setLogAbandoned(boolean logAbandoned) {<a name="line.1219"></a>
<FONT color="green">1220</FONT>            if (abandonedConfig == null) {<a name="line.1220"></a>
<FONT color="green">1221</FONT>                abandonedConfig = new AbandonedConfig();<a name="line.1221"></a>
<FONT color="green">1222</FONT>            }<a name="line.1222"></a>
<FONT color="green">1223</FONT>            abandonedConfig.setLogAbandoned(logAbandoned);<a name="line.1223"></a>
<FONT color="green">1224</FONT>            this.restartNeeded = true;<a name="line.1224"></a>
<FONT color="green">1225</FONT>        }<a name="line.1225"></a>
<FONT color="green">1226</FONT>    <a name="line.1226"></a>
<FONT color="green">1227</FONT>        // --------------------------------------------------------- Public Methods<a name="line.1227"></a>
<FONT color="green">1228</FONT>    <a name="line.1228"></a>
<FONT color="green">1229</FONT>        /**<a name="line.1229"></a>
<FONT color="green">1230</FONT>         * Add a custom connection property to the set that will be passed to our<a name="line.1230"></a>
<FONT color="green">1231</FONT>         * JDBC driver. This &lt;strong&gt;MUST&lt;/strong&gt; be called before the first<a name="line.1231"></a>
<FONT color="green">1232</FONT>         * connection is retrieved (along with all the other configuration<a name="line.1232"></a>
<FONT color="green">1233</FONT>         * property setters). Calls to this method after the connection pool<a name="line.1233"></a>
<FONT color="green">1234</FONT>         * has been initialized have no effect.<a name="line.1234"></a>
<FONT color="green">1235</FONT>         *<a name="line.1235"></a>
<FONT color="green">1236</FONT>         * @param name Name of the custom connection property<a name="line.1236"></a>
<FONT color="green">1237</FONT>         * @param value Value of the custom connection property<a name="line.1237"></a>
<FONT color="green">1238</FONT>         */<a name="line.1238"></a>
<FONT color="green">1239</FONT>        public void addConnectionProperty(String name, String value) {<a name="line.1239"></a>
<FONT color="green">1240</FONT>            connectionProperties.put(name, value);<a name="line.1240"></a>
<FONT color="green">1241</FONT>            this.restartNeeded = true;<a name="line.1241"></a>
<FONT color="green">1242</FONT>        }<a name="line.1242"></a>
<FONT color="green">1243</FONT>    <a name="line.1243"></a>
<FONT color="green">1244</FONT>        /**<a name="line.1244"></a>
<FONT color="green">1245</FONT>         * Remove a custom connection property.<a name="line.1245"></a>
<FONT color="green">1246</FONT>         * <a name="line.1246"></a>
<FONT color="green">1247</FONT>         * @param name Name of the custom connection property to remove<a name="line.1247"></a>
<FONT color="green">1248</FONT>         * @see #addConnectionProperty(String, String)<a name="line.1248"></a>
<FONT color="green">1249</FONT>         */<a name="line.1249"></a>
<FONT color="green">1250</FONT>        public void removeConnectionProperty(String name) {<a name="line.1250"></a>
<FONT color="green">1251</FONT>            connectionProperties.remove(name);<a name="line.1251"></a>
<FONT color="green">1252</FONT>            this.restartNeeded = true;<a name="line.1252"></a>
<FONT color="green">1253</FONT>        }<a name="line.1253"></a>
<FONT color="green">1254</FONT>    <a name="line.1254"></a>
<FONT color="green">1255</FONT>        /**<a name="line.1255"></a>
<FONT color="green">1256</FONT>         * Sets the connection properties passed to driver.connect(...).<a name="line.1256"></a>
<FONT color="green">1257</FONT>         *<a name="line.1257"></a>
<FONT color="green">1258</FONT>         * Format of the string must be [propertyName=property;]*<a name="line.1258"></a>
<FONT color="green">1259</FONT>         *<a name="line.1259"></a>
<FONT color="green">1260</FONT>         * NOTE - The "user" and "password" properties will be added<a name="line.1260"></a>
<FONT color="green">1261</FONT>         * explicitly, so they do not need to be included here.<a name="line.1261"></a>
<FONT color="green">1262</FONT>         *<a name="line.1262"></a>
<FONT color="green">1263</FONT>         * @param connectionProperties the connection properties used to<a name="line.1263"></a>
<FONT color="green">1264</FONT>         * create new connections<a name="line.1264"></a>
<FONT color="green">1265</FONT>         */<a name="line.1265"></a>
<FONT color="green">1266</FONT>        public void setConnectionProperties(String connectionProperties) {<a name="line.1266"></a>
<FONT color="green">1267</FONT>            if (connectionProperties == null) throw new NullPointerException("connectionProperties is null");<a name="line.1267"></a>
<FONT color="green">1268</FONT>    <a name="line.1268"></a>
<FONT color="green">1269</FONT>            String[] entries = connectionProperties.split(";");<a name="line.1269"></a>
<FONT color="green">1270</FONT>            Properties properties = new Properties();<a name="line.1270"></a>
<FONT color="green">1271</FONT>            for (int i = 0; i &lt; entries.length; i++) {<a name="line.1271"></a>
<FONT color="green">1272</FONT>                String entry = entries[i];<a name="line.1272"></a>
<FONT color="green">1273</FONT>                if (entry.length() &gt; 0) {<a name="line.1273"></a>
<FONT color="green">1274</FONT>                    int index = entry.indexOf('=');<a name="line.1274"></a>
<FONT color="green">1275</FONT>                    if (index &gt; 0) {<a name="line.1275"></a>
<FONT color="green">1276</FONT>                        String name = entry.substring(0, index);<a name="line.1276"></a>
<FONT color="green">1277</FONT>                        String value = entry.substring(index + 1);<a name="line.1277"></a>
<FONT color="green">1278</FONT>                        properties.setProperty(name, value);<a name="line.1278"></a>
<FONT color="green">1279</FONT>                    } else {<a name="line.1279"></a>
<FONT color="green">1280</FONT>                        // no value is empty string which is how java.util.Properties works<a name="line.1280"></a>
<FONT color="green">1281</FONT>                        properties.setProperty(entry, "");<a name="line.1281"></a>
<FONT color="green">1282</FONT>                    }<a name="line.1282"></a>
<FONT color="green">1283</FONT>                }<a name="line.1283"></a>
<FONT color="green">1284</FONT>            }<a name="line.1284"></a>
<FONT color="green">1285</FONT>            this.connectionProperties = properties;<a name="line.1285"></a>
<FONT color="green">1286</FONT>            this.restartNeeded = true;<a name="line.1286"></a>
<FONT color="green">1287</FONT>        }<a name="line.1287"></a>
<FONT color="green">1288</FONT>    <a name="line.1288"></a>
<FONT color="green">1289</FONT>        protected boolean closed;<a name="line.1289"></a>
<FONT color="green">1290</FONT>    <a name="line.1290"></a>
<FONT color="green">1291</FONT>        /**<a name="line.1291"></a>
<FONT color="green">1292</FONT>         * &lt;p&gt;Closes and releases all idle connections that are currently stored in the connection pool<a name="line.1292"></a>
<FONT color="green">1293</FONT>         * associated with this data source.&lt;/p&gt;<a name="line.1293"></a>
<FONT color="green">1294</FONT>         *<a name="line.1294"></a>
<FONT color="green">1295</FONT>         * &lt;p&gt;Connections that are checked out to clients when this method is invoked are not affected.  <a name="line.1295"></a>
<FONT color="green">1296</FONT>         * When client applications subsequently invoke {@link Connection#close()} to return<a name="line.1296"></a>
<FONT color="green">1297</FONT>         * these connections to the pool, the underlying JDBC connections are closed.&lt;/p&gt;<a name="line.1297"></a>
<FONT color="green">1298</FONT>         * <a name="line.1298"></a>
<FONT color="green">1299</FONT>         * &lt;p&gt;Attempts to acquire connections using {@link #getConnection()} after this method has been<a name="line.1299"></a>
<FONT color="green">1300</FONT>         * invoked result in SQLExceptions.&lt;p&gt;<a name="line.1300"></a>
<FONT color="green">1301</FONT>         * <a name="line.1301"></a>
<FONT color="green">1302</FONT>         * &lt;p&gt;This method is idempotent - i.e., closing an already closed BasicDataSource has no effect<a name="line.1302"></a>
<FONT color="green">1303</FONT>         * and does not generate exceptions.&lt;/p&gt;<a name="line.1303"></a>
<FONT color="green">1304</FONT>         * <a name="line.1304"></a>
<FONT color="green">1305</FONT>         * @throws SQLException if an error occurs closing idle connections<a name="line.1305"></a>
<FONT color="green">1306</FONT>         */<a name="line.1306"></a>
<FONT color="green">1307</FONT>        public synchronized void close() throws SQLException {<a name="line.1307"></a>
<FONT color="green">1308</FONT>            closed = true;<a name="line.1308"></a>
<FONT color="green">1309</FONT>            GenericObjectPool oldpool = connectionPool;<a name="line.1309"></a>
<FONT color="green">1310</FONT>            connectionPool = null;<a name="line.1310"></a>
<FONT color="green">1311</FONT>            dataSource = null;<a name="line.1311"></a>
<FONT color="green">1312</FONT>            try {<a name="line.1312"></a>
<FONT color="green">1313</FONT>                if (oldpool != null) {<a name="line.1313"></a>
<FONT color="green">1314</FONT>                    oldpool.close();<a name="line.1314"></a>
<FONT color="green">1315</FONT>                }<a name="line.1315"></a>
<FONT color="green">1316</FONT>            } catch(SQLException e) {<a name="line.1316"></a>
<FONT color="green">1317</FONT>                throw e;<a name="line.1317"></a>
<FONT color="green">1318</FONT>            } catch(RuntimeException e) {<a name="line.1318"></a>
<FONT color="green">1319</FONT>                throw e;<a name="line.1319"></a>
<FONT color="green">1320</FONT>            } catch(Exception e) {<a name="line.1320"></a>
<FONT color="green">1321</FONT>                throw new SQLNestedException("Cannot close connection pool", e);<a name="line.1321"></a>
<FONT color="green">1322</FONT>            }<a name="line.1322"></a>
<FONT color="green">1323</FONT>        }<a name="line.1323"></a>
<FONT color="green">1324</FONT>    <a name="line.1324"></a>
<FONT color="green">1325</FONT>        /**<a name="line.1325"></a>
<FONT color="green">1326</FONT>         * If true, this data source is closed and no more connections can be retrieved from this datasource.<a name="line.1326"></a>
<FONT color="green">1327</FONT>         * @return true, if the data source is closed; false otherwise<a name="line.1327"></a>
<FONT color="green">1328</FONT>         */<a name="line.1328"></a>
<FONT color="green">1329</FONT>        public synchronized boolean isClosed() {<a name="line.1329"></a>
<FONT color="green">1330</FONT>            return closed;<a name="line.1330"></a>
<FONT color="green">1331</FONT>        }<a name="line.1331"></a>
<FONT color="green">1332</FONT>    <a name="line.1332"></a>
<FONT color="green">1333</FONT>        /* JDBC_4_ANT_KEY_BEGIN */<a name="line.1333"></a>
<FONT color="green">1334</FONT>        public boolean isWrapperFor(Class&lt;?&gt; iface) throws SQLException {<a name="line.1334"></a>
<FONT color="green">1335</FONT>            return false;<a name="line.1335"></a>
<FONT color="green">1336</FONT>        }<a name="line.1336"></a>
<FONT color="green">1337</FONT>    <a name="line.1337"></a>
<FONT color="green">1338</FONT>        public &lt;T&gt; T unwrap(Class&lt;T&gt; iface) throws SQLException {<a name="line.1338"></a>
<FONT color="green">1339</FONT>            throw new SQLException("BasicDataSource is not a wrapper.");<a name="line.1339"></a>
<FONT color="green">1340</FONT>        }<a name="line.1340"></a>
<FONT color="green">1341</FONT>        /* JDBC_4_ANT_KEY_END */<a name="line.1341"></a>
<FONT color="green">1342</FONT>    <a name="line.1342"></a>
<FONT color="green">1343</FONT>            <a name="line.1343"></a>
<FONT color="green">1344</FONT>        // ------------------------------------------------------ Protected Methods<a name="line.1344"></a>
<FONT color="green">1345</FONT>    <a name="line.1345"></a>
<FONT color="green">1346</FONT>    <a name="line.1346"></a>
<FONT color="green">1347</FONT>        /**<a name="line.1347"></a>
<FONT color="green">1348</FONT>         * &lt;p&gt;Create (if necessary) and return the internal data source we are<a name="line.1348"></a>
<FONT color="green">1349</FONT>         * using to manage our connections.&lt;/p&gt;<a name="line.1349"></a>
<FONT color="green">1350</FONT>         *<a name="line.1350"></a>
<FONT color="green">1351</FONT>         * &lt;p&gt;&lt;strong&gt;IMPLEMENTATION NOTE&lt;/strong&gt; - It is tempting to use the<a name="line.1351"></a>
<FONT color="green">1352</FONT>         * "double checked locking" idiom in an attempt to avoid synchronizing<a name="line.1352"></a>
<FONT color="green">1353</FONT>         * on every single call to this method.  However, this idiom fails to<a name="line.1353"></a>
<FONT color="green">1354</FONT>         * work correctly in the face of some optimizations that are legal for<a name="line.1354"></a>
<FONT color="green">1355</FONT>         * a JVM to perform.&lt;/p&gt;<a name="line.1355"></a>
<FONT color="green">1356</FONT>         *<a name="line.1356"></a>
<FONT color="green">1357</FONT>         * @throws SQLException if the object pool cannot be created.<a name="line.1357"></a>
<FONT color="green">1358</FONT>         */<a name="line.1358"></a>
<FONT color="green">1359</FONT>        protected synchronized DataSource createDataSource()<a name="line.1359"></a>
<FONT color="green">1360</FONT>            throws SQLException {<a name="line.1360"></a>
<FONT color="green">1361</FONT>            if (closed) {<a name="line.1361"></a>
<FONT color="green">1362</FONT>                throw new SQLException("Data source is closed");<a name="line.1362"></a>
<FONT color="green">1363</FONT>            }<a name="line.1363"></a>
<FONT color="green">1364</FONT>    <a name="line.1364"></a>
<FONT color="green">1365</FONT>            // Return the pool if we have already created it<a name="line.1365"></a>
<FONT color="green">1366</FONT>            if (dataSource != null) {<a name="line.1366"></a>
<FONT color="green">1367</FONT>                return (dataSource);<a name="line.1367"></a>
<FONT color="green">1368</FONT>            }<a name="line.1368"></a>
<FONT color="green">1369</FONT>    <a name="line.1369"></a>
<FONT color="green">1370</FONT>            // create factory which returns raw physical connections<a name="line.1370"></a>
<FONT color="green">1371</FONT>            ConnectionFactory driverConnectionFactory = createConnectionFactory();<a name="line.1371"></a>
<FONT color="green">1372</FONT>    <a name="line.1372"></a>
<FONT color="green">1373</FONT>            // create a pool for our connections<a name="line.1373"></a>
<FONT color="green">1374</FONT>            createConnectionPool();<a name="line.1374"></a>
<FONT color="green">1375</FONT>    <a name="line.1375"></a>
<FONT color="green">1376</FONT>            // Set up statement pool, if desired<a name="line.1376"></a>
<FONT color="green">1377</FONT>            GenericKeyedObjectPoolFactory statementPoolFactory = null;<a name="line.1377"></a>
<FONT color="green">1378</FONT>            if (isPoolPreparedStatements()) {<a name="line.1378"></a>
<FONT color="green">1379</FONT>                statementPoolFactory = new GenericKeyedObjectPoolFactory(null,<a name="line.1379"></a>
<FONT color="green">1380</FONT>                            -1, // unlimited maxActive (per key)<a name="line.1380"></a>
<FONT color="green">1381</FONT>                            GenericKeyedObjectPool.WHEN_EXHAUSTED_FAIL,<a name="line.1381"></a>
<FONT color="green">1382</FONT>                            0, // maxWait<a name="line.1382"></a>
<FONT color="green">1383</FONT>                            1, // maxIdle (per key)<a name="line.1383"></a>
<FONT color="green">1384</FONT>                            maxOpenPreparedStatements);<a name="line.1384"></a>
<FONT color="green">1385</FONT>            }<a name="line.1385"></a>
<FONT color="green">1386</FONT>    <a name="line.1386"></a>
<FONT color="green">1387</FONT>            // Set up the poolable connection factory<a name="line.1387"></a>
<FONT color="green">1388</FONT>            createPoolableConnectionFactory(driverConnectionFactory, statementPoolFactory, abandonedConfig);<a name="line.1388"></a>
<FONT color="green">1389</FONT>    <a name="line.1389"></a>
<FONT color="green">1390</FONT>            // Create and return the pooling data source to manage the connections<a name="line.1390"></a>
<FONT color="green">1391</FONT>            createDataSourceInstance();<a name="line.1391"></a>
<FONT color="green">1392</FONT>            <a name="line.1392"></a>
<FONT color="green">1393</FONT>            try {<a name="line.1393"></a>
<FONT color="green">1394</FONT>                for (int i = 0 ; i &lt; initialSize ; i++) {<a name="line.1394"></a>
<FONT color="green">1395</FONT>                    connectionPool.addObject();<a name="line.1395"></a>
<FONT color="green">1396</FONT>                }<a name="line.1396"></a>
<FONT color="green">1397</FONT>            } catch (Exception e) {<a name="line.1397"></a>
<FONT color="green">1398</FONT>                throw new SQLNestedException("Error preloading the connection pool", e);<a name="line.1398"></a>
<FONT color="green">1399</FONT>            }<a name="line.1399"></a>
<FONT color="green">1400</FONT>            <a name="line.1400"></a>
<FONT color="green">1401</FONT>            return dataSource;<a name="line.1401"></a>
<FONT color="green">1402</FONT>        }<a name="line.1402"></a>
<FONT color="green">1403</FONT>    <a name="line.1403"></a>
<FONT color="green">1404</FONT>        /**<a name="line.1404"></a>
<FONT color="green">1405</FONT>         * Creates a JDBC connection factory for this datasource.  This method only<a name="line.1405"></a>
<FONT color="green">1406</FONT>         * exists so subclasses can replace the implementation class.<a name="line.1406"></a>
<FONT color="green">1407</FONT>         */<a name="line.1407"></a>
<FONT color="green">1408</FONT>        protected ConnectionFactory createConnectionFactory() throws SQLException {<a name="line.1408"></a>
<FONT color="green">1409</FONT>            // Load the JDBC driver class<a name="line.1409"></a>
<FONT color="green">1410</FONT>            Class driverFromCCL = null;<a name="line.1410"></a>
<FONT color="green">1411</FONT>            if (driverClassName != null) {<a name="line.1411"></a>
<FONT color="green">1412</FONT>                try {<a name="line.1412"></a>
<FONT color="green">1413</FONT>                    try {<a name="line.1413"></a>
<FONT color="green">1414</FONT>                        if (driverClassLoader == null) {<a name="line.1414"></a>
<FONT color="green">1415</FONT>                            Class.forName(driverClassName);<a name="line.1415"></a>
<FONT color="green">1416</FONT>                        } else {<a name="line.1416"></a>
<FONT color="green">1417</FONT>                            Class.forName(driverClassName, true, driverClassLoader);<a name="line.1417"></a>
<FONT color="green">1418</FONT>                        }<a name="line.1418"></a>
<FONT color="green">1419</FONT>                    } catch (ClassNotFoundException cnfe) {<a name="line.1419"></a>
<FONT color="green">1420</FONT>                        driverFromCCL = Thread.currentThread(<a name="line.1420"></a>
<FONT color="green">1421</FONT>                                ).getContextClassLoader().loadClass(<a name="line.1421"></a>
<FONT color="green">1422</FONT>                                        driverClassName);<a name="line.1422"></a>
<FONT color="green">1423</FONT>                    }<a name="line.1423"></a>
<FONT color="green">1424</FONT>                } catch (Throwable t) {<a name="line.1424"></a>
<FONT color="green">1425</FONT>                    String message = "Cannot load JDBC driver class '" +<a name="line.1425"></a>
<FONT color="green">1426</FONT>                        driverClassName + "'";<a name="line.1426"></a>
<FONT color="green">1427</FONT>                    logWriter.println(message);<a name="line.1427"></a>
<FONT color="green">1428</FONT>                    t.printStackTrace(logWriter);<a name="line.1428"></a>
<FONT color="green">1429</FONT>                    throw new SQLNestedException(message, t);<a name="line.1429"></a>
<FONT color="green">1430</FONT>                }<a name="line.1430"></a>
<FONT color="green">1431</FONT>            }<a name="line.1431"></a>
<FONT color="green">1432</FONT>    <a name="line.1432"></a>
<FONT color="green">1433</FONT>            // Create a JDBC driver instance<a name="line.1433"></a>
<FONT color="green">1434</FONT>            Driver driver = null;<a name="line.1434"></a>
<FONT color="green">1435</FONT>            try {<a name="line.1435"></a>
<FONT color="green">1436</FONT>                if (driverFromCCL == null) {<a name="line.1436"></a>
<FONT color="green">1437</FONT>                    driver = DriverManager.getDriver(url);<a name="line.1437"></a>
<FONT color="green">1438</FONT>                } else {<a name="line.1438"></a>
<FONT color="green">1439</FONT>                    // Usage of DriverManager is not possible, as it does not<a name="line.1439"></a>
<FONT color="green">1440</FONT>                    // respect the ContextClassLoader<a name="line.1440"></a>
<FONT color="green">1441</FONT>                    driver = (Driver) driverFromCCL.newInstance();<a name="line.1441"></a>
<FONT color="green">1442</FONT>                    if (!driver.acceptsURL(url)) {<a name="line.1442"></a>
<FONT color="green">1443</FONT>                        throw new SQLException("No suitable driver", "08001"); <a name="line.1443"></a>
<FONT color="green">1444</FONT>                    }<a name="line.1444"></a>
<FONT color="green">1445</FONT>                }<a name="line.1445"></a>
<FONT color="green">1446</FONT>            } catch (Throwable t) {<a name="line.1446"></a>
<FONT color="green">1447</FONT>                String message = "Cannot create JDBC driver of class '" +<a name="line.1447"></a>
<FONT color="green">1448</FONT>                    (driverClassName != null ? driverClassName : "") +<a name="line.1448"></a>
<FONT color="green">1449</FONT>                    "' for connect URL '" + url + "'";<a name="line.1449"></a>
<FONT color="green">1450</FONT>                logWriter.println(message);<a name="line.1450"></a>
<FONT color="green">1451</FONT>                t.printStackTrace(logWriter);<a name="line.1451"></a>
<FONT color="green">1452</FONT>                throw new SQLNestedException(message, t);<a name="line.1452"></a>
<FONT color="green">1453</FONT>            }<a name="line.1453"></a>
<FONT color="green">1454</FONT>    <a name="line.1454"></a>
<FONT color="green">1455</FONT>            // Can't test without a validationQuery<a name="line.1455"></a>
<FONT color="green">1456</FONT>            if (validationQuery == null) {<a name="line.1456"></a>
<FONT color="green">1457</FONT>                setTestOnBorrow(false);<a name="line.1457"></a>
<FONT color="green">1458</FONT>                setTestOnReturn(false);<a name="line.1458"></a>
<FONT color="green">1459</FONT>                setTestWhileIdle(false);<a name="line.1459"></a>
<FONT color="green">1460</FONT>            }<a name="line.1460"></a>
<FONT color="green">1461</FONT>    <a name="line.1461"></a>
<FONT color="green">1462</FONT>            // Set up the driver connection factory we will use<a name="line.1462"></a>
<FONT color="green">1463</FONT>            String user = username;<a name="line.1463"></a>
<FONT color="green">1464</FONT>            if (user != null) {<a name="line.1464"></a>
<FONT color="green">1465</FONT>                connectionProperties.put("user", user);<a name="line.1465"></a>
<FONT color="green">1466</FONT>            } else {<a name="line.1466"></a>
<FONT color="green">1467</FONT>                log("DBCP DataSource configured without a 'username'");<a name="line.1467"></a>
<FONT color="green">1468</FONT>            }<a name="line.1468"></a>
<FONT color="green">1469</FONT>    <a name="line.1469"></a>
<FONT color="green">1470</FONT>            String pwd = password;<a name="line.1470"></a>
<FONT color="green">1471</FONT>            if (pwd != null) {<a name="line.1471"></a>
<FONT color="green">1472</FONT>                connectionProperties.put("password", pwd);<a name="line.1472"></a>
<FONT color="green">1473</FONT>            } else {<a name="line.1473"></a>
<FONT color="green">1474</FONT>                log("DBCP DataSource configured without a 'password'");<a name="line.1474"></a>
<FONT color="green">1475</FONT>            }<a name="line.1475"></a>
<FONT color="green">1476</FONT>    <a name="line.1476"></a>
<FONT color="green">1477</FONT>            ConnectionFactory driverConnectionFactory = new DriverConnectionFactory(driver, url, connectionProperties);<a name="line.1477"></a>
<FONT color="green">1478</FONT>            return driverConnectionFactory;<a name="line.1478"></a>
<FONT color="green">1479</FONT>        }<a name="line.1479"></a>
<FONT color="green">1480</FONT>    <a name="line.1480"></a>
<FONT color="green">1481</FONT>        /**<a name="line.1481"></a>
<FONT color="green">1482</FONT>         * Creates a connection pool for this datasource.  This method only exists<a name="line.1482"></a>
<FONT color="green">1483</FONT>         * so subclasses can replace the implementation class.<a name="line.1483"></a>
<FONT color="green">1484</FONT>         */<a name="line.1484"></a>
<FONT color="green">1485</FONT>        protected void createConnectionPool() {<a name="line.1485"></a>
<FONT color="green">1486</FONT>            // Create an object pool to contain our active connections<a name="line.1486"></a>
<FONT color="green">1487</FONT>            GenericObjectPool gop;<a name="line.1487"></a>
<FONT color="green">1488</FONT>            if ((abandonedConfig != null) &amp;&amp; (abandonedConfig.getRemoveAbandoned())) {<a name="line.1488"></a>
<FONT color="green">1489</FONT>                gop = new AbandonedObjectPool(null,abandonedConfig);<a name="line.1489"></a>
<FONT color="green">1490</FONT>            }<a name="line.1490"></a>
<FONT color="green">1491</FONT>            else {<a name="line.1491"></a>
<FONT color="green">1492</FONT>                gop = new GenericObjectPool();<a name="line.1492"></a>
<FONT color="green">1493</FONT>            }<a name="line.1493"></a>
<FONT color="green">1494</FONT>            gop.setMaxActive(maxActive);<a name="line.1494"></a>
<FONT color="green">1495</FONT>            gop.setMaxIdle(maxIdle);<a name="line.1495"></a>
<FONT color="green">1496</FONT>            gop.setMinIdle(minIdle);<a name="line.1496"></a>
<FONT color="green">1497</FONT>            gop.setMaxWait(maxWait);<a name="line.1497"></a>
<FONT color="green">1498</FONT>            gop.setTestOnBorrow(testOnBorrow);<a name="line.1498"></a>
<FONT color="green">1499</FONT>            gop.setTestOnReturn(testOnReturn);<a name="line.1499"></a>
<FONT color="green">1500</FONT>            gop.setTimeBetweenEvictionRunsMillis(timeBetweenEvictionRunsMillis);<a name="line.1500"></a>
<FONT color="green">1501</FONT>            gop.setNumTestsPerEvictionRun(numTestsPerEvictionRun);<a name="line.1501"></a>
<FONT color="green">1502</FONT>            gop.setMinEvictableIdleTimeMillis(minEvictableIdleTimeMillis);<a name="line.1502"></a>
<FONT color="green">1503</FONT>            gop.setTestWhileIdle(testWhileIdle);<a name="line.1503"></a>
<FONT color="green">1504</FONT>            connectionPool = gop;<a name="line.1504"></a>
<FONT color="green">1505</FONT>        }<a name="line.1505"></a>
<FONT color="green">1506</FONT>    <a name="line.1506"></a>
<FONT color="green">1507</FONT>        /**<a name="line.1507"></a>
<FONT color="green">1508</FONT>         * Creates the actual data source instance.  This method only exists so<a name="line.1508"></a>
<FONT color="green">1509</FONT>         * subclasses can replace the implementation class.<a name="line.1509"></a>
<FONT color="green">1510</FONT>         * <a name="line.1510"></a>
<FONT color="green">1511</FONT>         * @throws SQLException if unable to create a datasource instance<a name="line.1511"></a>
<FONT color="green">1512</FONT>         */<a name="line.1512"></a>
<FONT color="green">1513</FONT>        protected void createDataSourceInstance() throws SQLException {<a name="line.1513"></a>
<FONT color="green">1514</FONT>            PoolingDataSource pds = new PoolingDataSource(connectionPool);<a name="line.1514"></a>
<FONT color="green">1515</FONT>            pds.setAccessToUnderlyingConnectionAllowed(isAccessToUnderlyingConnectionAllowed());<a name="line.1515"></a>
<FONT color="green">1516</FONT>            pds.setLogWriter(logWriter);<a name="line.1516"></a>
<FONT color="green">1517</FONT>            dataSource = pds;<a name="line.1517"></a>
<FONT color="green">1518</FONT>        }<a name="line.1518"></a>
<FONT color="green">1519</FONT>    <a name="line.1519"></a>
<FONT color="green">1520</FONT>        /**<a name="line.1520"></a>
<FONT color="green">1521</FONT>         * Creates the PoolableConnectionFactory and attaches it to the connection pool.  This method only exists<a name="line.1521"></a>
<FONT color="green">1522</FONT>         * so subclasses can replace the default implementation.<a name="line.1522"></a>
<FONT color="green">1523</FONT>         * <a name="line.1523"></a>
<FONT color="green">1524</FONT>         * @param driverConnectionFactory JDBC connection factory<a name="line.1524"></a>
<FONT color="green">1525</FONT>         * @param statementPoolFactory statement pool factory (null if statement pooling is turned off)<a name="line.1525"></a>
<FONT color="green">1526</FONT>         * @param configuration abandoned connection tracking configuration (null if no tracking)<a name="line.1526"></a>
<FONT color="green">1527</FONT>         * @throws SQLException if an error occurs creating the PoolableConnectionFactory<a name="line.1527"></a>
<FONT color="green">1528</FONT>         */<a name="line.1528"></a>
<FONT color="green">1529</FONT>        protected void createPoolableConnectionFactory(ConnectionFactory driverConnectionFactory,<a name="line.1529"></a>
<FONT color="green">1530</FONT>                KeyedObjectPoolFactory statementPoolFactory, AbandonedConfig configuration) throws SQLException {<a name="line.1530"></a>
<FONT color="green">1531</FONT>            PoolableConnectionFactory connectionFactory = null;<a name="line.1531"></a>
<FONT color="green">1532</FONT>            try {<a name="line.1532"></a>
<FONT color="green">1533</FONT>                connectionFactory =<a name="line.1533"></a>
<FONT color="green">1534</FONT>                    new PoolableConnectionFactory(driverConnectionFactory,<a name="line.1534"></a>
<FONT color="green">1535</FONT>                                                  connectionPool,<a name="line.1535"></a>
<FONT color="green">1536</FONT>                                                  statementPoolFactory,<a name="line.1536"></a>
<FONT color="green">1537</FONT>                                                  validationQuery,<a name="line.1537"></a>
<FONT color="green">1538</FONT>                                                  validationQueryTimeout,<a name="line.1538"></a>
<FONT color="green">1539</FONT>                                                  connectionInitSqls,<a name="line.1539"></a>
<FONT color="green">1540</FONT>                                                  defaultReadOnly,<a name="line.1540"></a>
<FONT color="green">1541</FONT>                                                  defaultAutoCommit,<a name="line.1541"></a>
<FONT color="green">1542</FONT>                                                  defaultTransactionIsolation,<a name="line.1542"></a>
<FONT color="green">1543</FONT>                                                  defaultCatalog,<a name="line.1543"></a>
<FONT color="green">1544</FONT>                                                  configuration);<a name="line.1544"></a>
<FONT color="green">1545</FONT>                validateConnectionFactory(connectionFactory);<a name="line.1545"></a>
<FONT color="green">1546</FONT>            } catch (RuntimeException e) {<a name="line.1546"></a>
<FONT color="green">1547</FONT>                throw e;<a name="line.1547"></a>
<FONT color="green">1548</FONT>            } catch (Exception e) {<a name="line.1548"></a>
<FONT color="green">1549</FONT>                throw new SQLNestedException("Cannot create PoolableConnectionFactory (" + e.getMessage() + ")", e);<a name="line.1549"></a>
<FONT color="green">1550</FONT>            }<a name="line.1550"></a>
<FONT color="green">1551</FONT>        }<a name="line.1551"></a>
<FONT color="green">1552</FONT>    <a name="line.1552"></a>
<FONT color="green">1553</FONT>        protected static void validateConnectionFactory(PoolableConnectionFactory connectionFactory) throws Exception {<a name="line.1553"></a>
<FONT color="green">1554</FONT>            Connection conn = null;<a name="line.1554"></a>
<FONT color="green">1555</FONT>            try {<a name="line.1555"></a>
<FONT color="green">1556</FONT>                conn = (Connection) connectionFactory.makeObject();<a name="line.1556"></a>
<FONT color="green">1557</FONT>                connectionFactory.activateObject(conn);<a name="line.1557"></a>
<FONT color="green">1558</FONT>                connectionFactory.validateConnection(conn);<a name="line.1558"></a>
<FONT color="green">1559</FONT>                connectionFactory.passivateObject(conn);<a name="line.1559"></a>
<FONT color="green">1560</FONT>            }<a name="line.1560"></a>
<FONT color="green">1561</FONT>            finally {<a name="line.1561"></a>
<FONT color="green">1562</FONT>                connectionFactory.destroyObject(conn);<a name="line.1562"></a>
<FONT color="green">1563</FONT>            }<a name="line.1563"></a>
<FONT color="green">1564</FONT>        }<a name="line.1564"></a>
<FONT color="green">1565</FONT>    <a name="line.1565"></a>
<FONT color="green">1566</FONT>        /**<a name="line.1566"></a>
<FONT color="green">1567</FONT>         * Not used currently<a name="line.1567"></a>
<FONT color="green">1568</FONT>         */<a name="line.1568"></a>
<FONT color="green">1569</FONT>        private void restart() {<a name="line.1569"></a>
<FONT color="green">1570</FONT>            try {<a name="line.1570"></a>
<FONT color="green">1571</FONT>                close();<a name="line.1571"></a>
<FONT color="green">1572</FONT>            } catch (SQLException e) {<a name="line.1572"></a>
<FONT color="green">1573</FONT>                log("Could not restart DataSource, cause: " + e.getMessage());<a name="line.1573"></a>
<FONT color="green">1574</FONT>            }<a name="line.1574"></a>
<FONT color="green">1575</FONT>        }<a name="line.1575"></a>
<FONT color="green">1576</FONT>    <a name="line.1576"></a>
<FONT color="green">1577</FONT>        protected void log(String message) {<a name="line.1577"></a>
<FONT color="green">1578</FONT>            if (logWriter != null) {<a name="line.1578"></a>
<FONT color="green">1579</FONT>                logWriter.println(message);<a name="line.1579"></a>
<FONT color="green">1580</FONT>            }<a name="line.1580"></a>
<FONT color="green">1581</FONT>        }<a name="line.1581"></a>
<FONT color="green">1582</FONT>    }<a name="line.1582"></a>




























































</PRE>
</BODY>
</HTML>
